Forum Discussion
Signals_total in Wellbeing Dashboard
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
MicrosoftHi 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