Signals_total in Wellbeing Dashboard

[David_Ledenstam]

Hello! We are currently exploring the Wellbeing Dashboard, and seeing how we could use the data export for custom analysis. A difference between the excel and the template dataset is "Signals_total", which is used to calculate in the "Take a break" tab but does not exist as a metric in the csv file. How exactly is this metric calculated? F.e. our query is grouped on a weekly basis. Would the Signals_totals be an average signal for each day of the week? 

Best regards,

David Ledenstam

[Stacey_Fang · Accepted solution]

Hi David,

Thank you for reaching out. 

You may find the actual calculation of signals by hour and signals_total through Power query in Power BI. Go to the dashboard in Power BI --> Transform data --> Wellbeing query --> Added Signals Total step.

In a weekly hourly collaboration query, signal by hour is a binary value (0,1) calculated by sum of total activities for that hour (email, meeting, call, chat). If sum of that hour >0, signal for that hour is 1, otherwise 0. Signals total adds up the signals for 24 hours in the weekly query. For example, if signal 8_9 and signal 10_11 are both 1 and signals for other hours are 0, signals total is 2.

Please be noted that since this is a weekly query, as long as this person had an activity during that hour (any day of week), that hour will be counted as 1 in total signals for the week. We are working on a new solution that could get us to a more accurate estimate for the week such as a daily average, so please stay tuned. In the meanwhile, if you'd like a more accurate calculation to capture the daily average active blocks, you could run hourly collaboration query by day and take the average from there, although it's a significantly larger set of data for analysis.

Hope this helps.

Best,

Stacey