Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I can't understand how set analysis works in this case, because despite having inserted into the measure what I am looking for and having told the measure to use the set analysis over each function that needs it, the results do not match.
See screenshots below, when I don't select any employee, the measure 'Team Measure' works fine:
However, when I select an employee, the measure suddenly turns to the same output as the employee selected:
This is the measure I am currently using:
// All Other Employees Measure
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Avg_Time,
MainSFC, Employee
)
)
/
(
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count(distinct WorkingDay) * 7.5 * 60,
Employee
)
)
-
Sum(Absence) * 60
)
Can someone please help me figure out what I am doing wrong?
Hi @alespooletto,
Check with this:
Sum(
Aggr(
Count({< ACTION_CODE = {'LABOR_OFF'}, Employee= >} distinct MainSFC) * Avg_Time,
MainSFC, Employee
)
)
/
(
Sum(
Aggr(
Count({< Employee= >} distinct WorkingDay) * 7.5 * 60,
Employee
)
)
- Sum(Absence) * 60
)
***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***
Thank you so much, unfortunately this measure as it is does not show me any values. Thanks for the help though, I am struggling to understand set analysis