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.SolvedNONTLAHLA_MJIKELOJul 05, 2024Brass Contributor377Views0likes1CommentVIVA 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!SolvedgilligansislandDec 08, 2023Copper Contributor540Views0likes1CommentConfirm 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 FranSolvedFran_KhooDec 07, 2023Copper Contributor573Views0likes1CommentModifying 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.Solvedhdsouza5Nov 29, 2023Copper Contributor456Views0likes1CommentIssue 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, PietroSolvedpietroasnaghiOct 30, 2023Copper Contributor589Views0likes3CommentsManager 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 () )Solvedkb2010Oct 24, 2023Brass Contributor448Views0likes1CommentCross-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.SolvedNONTLAHLA_MJIKELOOct 19, 2023Brass Contributor447Views0likes1CommentMetrics 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!SolvedRoman01Oct 18, 2023Copper Contributor450Views0likes1CommentDoes 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?Solved612Views0likes3Comments
Resources
Tags
- Power BI and query performance17 Topics
- Report templates14 Topics
- Ways of working8 Topics
- Custom queries7 Topics
- Metric customizations and rules7 Topics
- Wellbeing6 Topics
- Miscellaneous5 Topics
- Business leader inspiration4 Topics
- Organizational networks4 Topics
- Analyst workbench4 Topics