Unique employees per year next to multiple dimensions

[janwillem]

Hi,

At the moment I am working on a graph that shows the percentage of employees that leave our company per age group.

When I calculate the number of unique employees per year to show the percentage only one age group appears in the graph.

I made a table to see what happens. When I use the expression count({<EmployeeNumber= {"*"}-{0}, AgeGroup=,WorkingYears=>} DISTINCT EmployeeNumber)  only one age group has the number of unique employees.

Which expression do I need to use to see the number of unique employees at every age group?

Thanks in advance!

Jan Willem Tiemessen

[sunny_talwar]

Are you using an Aggr() function somewhere

[neelamsaroha157 · Accepted solution]

If you are using Aggr() function then use NODISTINCT with it.

like Aggr(NODISTINCT Count(Distinct EmployeeNumber), Year).

You can add your set expression to it as needed.

[janwillem]

NODISTINCT is the solution! Thanks!