Duplicate Employees??

[pablomind]

I need help with this: I need to know how many duplicates (employees) I have based in if they have the same Last Name and Date of Birth but different ID then count it. Any suggestion?

So far I had this:

= Sum(Aggr(If(Count(Last_Name)>1,1,0),Date_Birth))

But is not working right... Should I also make another Aggr of Employee_ID???

[kaushiknsolanki]

Do one thing.

Create a chart with Employee Name and Date of Birth

And expression as Count(Distinct EmployeeID)

Ans sort the data by 'Y' value.

Regards,

Kaushik Solanki

[sunny_talwar]

May be create a calculated Dimension:

[Last Name] &  ' ' & Date([Date of Birth])

and Expression: Concat(ID, ', ') to know the ID's associated with each of the combination

or Count(ID) to know how many IDs are associated with each combination

[tresesco]

May be like:

Sum(Aggr(If(Count(Last_Name)>1,1,0),ID,Date_Birth))

[pablomind · Accepted solution]

Thank you for your suggestions. At the end I could solved it doing this:

= Sum(Aggr(If(Count(ID)>1,1,0),Date_Birth,Last_Name))