Forum Discussion
Solved
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 bel...
- Hi kb2010,
The metric you refer to, "% of employees with no 1:1 with their manager", looks at the percentage of employees who did not have a 1:1 with their manager in the past 2 weeks. It is designed this way to align with the best practice of having at least 1 manager 1:1 with your manager per 2 weeks. For the trends, the rolling window does look back 4 weeks. In case you wish to customize the metric such that it calculates the % of employees who did not have a 1:1 with their manager in the past 4 weeks you would indeed have to adjust the base metric ([_Meetings with manager 1 on 1 last 2 weeks]) to look at last 4 weeks instead of 2 weeks and also update the logic in the measures being used in the visuals to [_Meetings with manager 1 on 1 last 2 weeks]>=1 instead of [_Meetings with manager 1 on 1 last 2 weeks]=0.
Florine_Segers
Microsoft
MicrosoftHi kb2010,
The metric you refer to, "% of employees with no 1:1 with their manager", looks at the percentage of employees who did not have a 1:1 with their manager in the past 2 weeks. It is designed this way to align with the best practice of having at least 1 manager 1:1 with your manager per 2 weeks. For the trends, the rolling window does look back 4 weeks. In case you wish to customize the metric such that it calculates the % of employees who did not have a 1:1 with their manager in the past 4 weeks you would indeed have to adjust the base metric ([_Meetings with manager 1 on 1 last 2 weeks]) to look at last 4 weeks instead of 2 weeks and also update the logic in the measures being used in the visuals to [_Meetings with manager 1 on 1 last 2 weeks]>=1 instead of [_Meetings with manager 1 on 1 last 2 weeks]=0.
The metric you refer to, "% of employees with no 1:1 with their manager", looks at the percentage of employees who did not have a 1:1 with their manager in the past 2 weeks. It is designed this way to align with the best practice of having at least 1 manager 1:1 with your manager per 2 weeks. For the trends, the rolling window does look back 4 weeks. In case you wish to customize the metric such that it calculates the % of employees who did not have a 1:1 with their manager in the past 4 weeks you would indeed have to adjust the base metric ([_Meetings with manager 1 on 1 last 2 weeks]) to look at last 4 weeks instead of 2 weeks and also update the logic in the measures being used in the visuals to [_Meetings with manager 1 on 1 last 2 weeks]>=1 instead of [_Meetings with manager 1 on 1 last 2 weeks]=0.