estimated value of time spent in meetings-calculate

[lmuca]

Hi all,

I am working with the new query templates of Viva Insights, in particular with Meetings effectiveness query.

I don't understand how the estimated value of time spent in meetings is being calculated. I see that the formula is as shown below:

_ValueOfTime_in_meeting =

CALCULATE (

    SUM ( 'Meeting Effectiveness'[Meeting hours] )

        * SELECTEDVALUE ( 'Value of meeting hour'[Value of meeting hour] )

)

The column " 'Value of meeting hour'[Value of meeting hour] " is the column of a table created in power bi: 

Value of meeting hour = GENERATESERIES(0, 1000, 1)

What does that series mean? What is it's function and why it goes from 0 to 1000?

Thank you very much in advance.

Lorina

[Dazza]

Hi @lmuca, 

I don't have an answer, but I'm intrigued by this formula as well. 

@Lucas_Hogner  or @Jake_Caddes - would you be able to refer us to someone that can explain this?