Advanced Insights | Microsoft Community Hub

Forum Widgets

Latest Discussions

Explore the impact of change
Hi Team I'm trying to run the new Explore the impact of change Template from Viva and this is the error I'm getting " This attribute has to many values. The report support about 100 values from an attribute" All our attributes have more than 10000 values and we are interested to see the change and explorer this template but now we have a limitation.
Solved
NONTLAHLA_MJIKELO
Brass Contributor
Jul 05, 2024
Report templates
377Views
0likes
1Comment
VIVA Insights Python - How to use my organizations data as opposed to the demo file
Hi all, a bit rusty have not used Python in about 2 years. VSCode is my IDE for reference. I have installed the vivainsights package and have it working with the sample data file. How do I begin to analyze my organizations data using Python? Thanks!
Solved
gilligansisland
Copper Contributor
Dec 08, 2023
Analyst workbench
Custom queries
Metric customizations and rules
Personal Insights
Set-up and deployment
538Views
0likes
1Comment
Confirm my understanding of Collaboration Exclusions Metric Rule, and edit this rule
Hi, From my understanding of the Collaboration Exclusions Metric rule (which Microsoft is the author), a meeting is NOT counted as collaboration, if no one has joined on Teams. Does this mean 1. If a meeting doesn't have a teams invite (is completely face to face), it is NOT captured as a collaborative meeting? 2. If a meeting has a teams invite, but everyone attending the meeting is present in person and hence no one logs into Teams for this meeting, this is NOT captured as a collaborative meeting? We see number 2 happening more and more frequently, and I am concerned we are undercounting our meeting hours. Appreciate if Microsoft can confirm this, and provide a fix if this is the case? I seem to be unable to edit the Metric rule to remove this requirement. Thank you. Rgds Fran
Solved
Fran_Khoo
Copper Contributor
Dec 07, 2023
Metric customizations and rules
573Views
0likes
1Comment
Modifying Viva Insights via GraphApi or Powershell
Hi, I can use "Viva Insights" to modify my office hours via https://insights.viva.office.com/#/PersonalApp/AppSettings/WorkWeekSettings/ How do I modify the same via GraphApi or PowerShell or some automated means? We have to modify the properties for over 2000 users and I am looking at an automated way.
Solved
hdsouza5
Copper Contributor
Nov 29, 2023
Custom queries
456Views
0likes
1Comment
Measuring meetings as attended
Hi All, If an individual schedules a meeting in Teams with a colleague, they both accept, but then they meet physically and dont join the meeting is this still considered as attended in the Viva Insights dashboard reports? thanks
Solved
emma_606
Copper Contributor
Nov 15, 2023
Custom queries
Metric customizations and rules
Report templates
559Views
0likes
1Comment
Issue with Wellbeing - Balance and flexibility PowerBI Dashboard
Hi all, I tried to run the "Wellbeing - Balance and flexibility" PowerBI Dashboard, but I found some errors, I attach the screenshot: I also found that in the query there are some warnings that I show you in the next screenshot: May you suggest me how to proceed? Is there some ways to fix it? Thank you in advance, Pietro
Solved
pietroasnaghi
Copper Contributor
Oct 30, 2023
Report templates
589Views
0likes
3Comments
Manager Effectiveness PowerBI report (No Manager 1:1 definition)
Can someone from microsoft help me understand why the Powerbi report which calculates a rolling four week average only uses 2 weeks to calculate if a person has met with their manager in the code below. Is the intent to show %of people not meeting with their manager at least once a week? So if an organization wants to show how many people met with their managers at least once in the last four week I would need to adjust the base metric ([_Meetings with manager 1 on 1 last 2 weeks]) to look at last 4 weeks instead of 2 weeks correct? % of employees with no 1:1 with their manager - rolling 4 weeks = VAR LogicTest = '_All Measures'[BT_Slicer_4w_Rolling_Average] VAR __REPORT_FIRST_DATE = '_All Measures'[First date all] VAR __date = SELECTEDVALUE ( 'Manager effectiveness query'[MetricDate] ) VAR __last_4_week = DATESINPERIOD ( 'Manager effectiveness query'[MetricDate], __date, -28, DAY ) VAR metric = AVERAGEX ( __last_4_week, VAR __numerator = CALCULATE ( COUNT ( 'Manager effectiveness query'[PersonId] ), 'Manager effectiveness query'[_Meetings with manager 1 on 1 last 2 weeks] = 0 ) VAR __denominator = CALCULATE ( COUNT ( 'Manager effectiveness query'[PersonId] ) ) RETURN DIVIDE ( __numerator, __denominator, 0 ) ) RETURN IF ( LogicTest && __date >= __REPORT_FIRST_DATE + 21, IF ( [Num Of Employees] >= SELECTEDVALUE ( 'Minimum group size'[Minimum group size] ), metric ), BLANK () )
Solved
kb2010
Brass Contributor
Oct 24, 2023
Manager and leader insights
Report templates
448Views
0likes
1Comment
Cross-collaboration query
Hello team We trying to run cross collaboration queries to do some analysis. The issue is that we can only download the CV only no powerbi available. We also tried to copy the links to existing templates to see if it will work but it's not working.
Solved
NONTLAHLA_MJIKELO
Brass Contributor
Oct 19, 2023
Custom queries
447Views
0likes
1Comment
Metrics clarity "Collaboration hours" in Multitasked report
Do you know in this report "Meeting effectiveness" -> "Multitasked" -> "Type of multitasker" what "Collaboration hours" means, is it per 4 weeks or per 1 week? Nothing in documentation and hard to explain to the customer. Thank you!
Solved
Roman01
Copper Contributor
Oct 18, 2023
Report templates
449Views
0likes
1Comment
Does the attended metric take into account double booked meetings?
A client stumped me with this question: If I am triple booked for an hour on my calendar, and I've accepted all three meetings, and they all show as busy on my calendar, do I count as an attendee for all three simultaneously occurring meetings? My response based on the definitions below was yes, but I wanted to double check and confirm. Attended A person attended a meeting if they either accepted the meeting and their meeting shows as “Busy” in Outlook, joined on Teams, or were the organizer. Attendee A person who was invited and attended the meeting. After spending a few hours with the documentation, I can't find anything that would say there is some sort of control to account for this. I imagine it's a limitation of measuring attendance for in-person meetings. Is that the case?
Solved
pSpurrs
Copper Contributor
Oct 03, 2023
Custom queries
Metric customizations and rules
Report templates
611Views
0likes
3Comments

Resources

Tags