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 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 ()
)
- 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.
1 Reply
Florine_SegersMicrosoft
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.