Forum Discussion
Signals_total in Wellbeing Dashboard
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
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
1 Reply
Stacey_FangMicrosoft
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