User Profile

Stacey_Fang

Microsoft

Joined Apr 13, 2023

7 Posts2 LikesLikes received4 Solutions

View All Badges

User Widgets

Recent Discussions

Re: Issue with Wellbeing - Balance and flexibility PowerBI Dashboard
pietroasnaghi Hi Pietro, I'm sorry that you experienced this. There has been an update to the Active connected hours metric recently, and some errors may show in previously run templates. Could you try run a new Wellbeing query by clicking on the "Wellbeing - balance and flexibility" template and go through the query creation process including downloading the new PBI template and loading the queries in the new template? On your second question on the warning signs in some of the metrics, please check the warning message on top of the query page - see below screenshot for an example. The warning message should explain the possible causes. Please let me know if the new template goes through, and don't hesitate to reach out with questions. If you still experience errors, please open a ticket so that the team can investigate further. Thank you for your patience.
Nov 13, 2023 Place Advanced Insights
501Views
0likes
0Comments
Re: Wellbeing Dashboard Calculations
Thanks Jake! On the calculation for breaks, this is to look at recurring breaks during working hours for the week, meaning if the person was inactive (i.e., didn't send an email/chat or didn't attend a meeting/call) during 12-1pm every day of the week, that hour will be counted as a recurring break. It could be that a person honors the lunch break to spend time with family and friends, or if the recurring break happens during school open/close hours, it could be that the person carries the duty to send/pick up kids from school, and come back to work afterwards. This is calculated by running an hourly collaboration query (weekly query) where each column represents one hour block of the day (e.g., 7-8AM, 8-9AM) and number of collaboration activities happened in that hour block for the week. If the number of activity is 0 for that hour block, this meant the person was inactive during this hour block each day of the week. Thus, this person is classified as having recurring breaks for this week. Hope this helps.
Nov 02, 2022 Place Advanced Insights
1.9KViews
1like
0Comments
Re: Collaboration activity patterns - measurement issue
Hi AngieS, Thank you for reaching out. I'm not sure what exactly you are seeing in that chart, but one possible explanation is that active hour block (y axis) is calculated based on a week-aggregate approach. The report is run on weekly queries with one of them called hourly collaboration query where it shows employees' collaboration activities by channel (email, meeting, call, chat) by hour (9-10, 10-11 etc.). Since it's a week-aggregate report, as long as the employee had an activity during that hour block any day of the week (e.g., sent an email at 6-7AM on Wednesday and didn't collaborate during this hour rest of the week), that hour block will be counted as active for that week. This could potentially overcount people's active blocks which may result in what you saw as higher hours of activity and lower hours of inactivity. This was a trade-off made to avoid pulling significantly larger set of data which could impact the report performance. That said, we are working on a new solution to update this report and bring in a more accurate measurement of employees' active hours. Thanks for your understanding, and please stay tuned. ---------------------- If you'd like to explore how to measure it in a more accurate way in a custom way, please see below paragraph: There is a way to measure the active blocks more accurately in a manual way. To go that route, you could run hourly collaboration query by day, add a column for each hour block to indicate whether the user is active during that block each day (e.g., if there's any activity - email, meeting, call, chat - during that block for the day, that block is active), add a column that counts the active block for the day. Then take the daily average by week. Map this daily average by week information with rest of the weekly queries for the report.
Oct 12, 2022 Place Advanced Insights
2.1KViews
0likes
1Comment
Re: 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
Oct 12, 2022 Place Advanced Insights
1.4KViews
0likes
0Comments
Re: Employee Burnout metrics to include insights on documents worked on
This is great feedback. Thank you, David! This will be taken into consideration as we continue to develop wellbeing features.
Dec 01, 2021 Place Give feedback and feature suggestions
5KViews
0likes
0Comments
Re: Productivity Guru for Teams/Outlook
Hi Oliver, Thank you so much for sharing! These are great ideas and we will take those into account as we plan for future features.
Oct 22, 2021 Place Give feedback and feature suggestions
1.8KViews
0likes
0Comments

Recent Blog Articles

Dive deeper into workforce patterns with new Viva Insights Impact explorer and Onboarding
Now announcing two new report templates that will be available for Viva Insights worldwide by the end of July.
Jul 17, 2023 Place Viva Insights Blog
4.5KViews
1like
0Comments