topic Why my set analysis is not working for all my group ? in App Development

Why my set analysis is not working for all my group ?

alespooletto — Thu, 06 Jun 2024 08:27:57 GMT

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?

Re: Why my set analysis is not working for all my group ?

TauseefKhan — Thu, 06 Jun 2024 08:44:16 GMT

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.***

Re: Why my set analysis is not working for all my group ?

alespooletto — Thu, 06 Jun 2024 14:30:20 GMT

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