estimated value of time spent in meetings-calculate

Question

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&nbsp;estimated value of time spent in meetings is being calculated. I see that the formula is as shown below:_ValueOfTime_in_meeting = CALCULATE (&nbsp; &nbsp; SUM ( 'Meeting Effectiveness'[Meeting hours] )&nbsp; &nbsp; &nbsp; &nbsp; * SELECTEDVALUE ( 'Value of meeting hour'[Value of meeting hour] ))&nbsp;The column " 'Value of meeting hour'[Value of meeting hour] " is the column of a table created in power bi:&nbsp;Value of meeting hour = GENERATESERIES(0, 1000, 1)&nbsp;What does that series mean? What is it's function and why it goes from 0 to 1000?&nbsp;Thank you very much in advance.&nbsp;Lorina

vi_migration · Answer

Hi&nbsp;lorinamuca,&nbsp;I don't have an answer, but I'm intrigued by this formula as well.&nbsp;luhogner&nbsp; or Jake_Caddes&nbsp;- would you be able to refer us to someone that can explain this?&nbsp;

Forum Discussion

estimated value of time spent in meetings-calculate

1 Reply