How to create Single Score report to show duplicates

[Community Alums]

Hello,

I would like to create a single score report to show the number of duplicate user accounts.  I see Count and Count distinct, but I'm not sure how to filter on those with Count greater than 1.  I'm sure its something very simple that I'm missing.  Anyone care to help me out?

Thanks!

[Byron_Payton]

If you're using the legacy server API you can use the GlideAggregate object and the .addHaving method to limit those with a COUNT > 1.  I don't see that method available for the scoped version of GlideAggregate.

[Ashutosh Munot1 · Accepted solution]

HI,

Below is the solution:

1) Script include as below:

2) Report as below:

NOTE: In my case in script include and report i used email as common identifier. you can change it as per need.

Thanks,
Ashutosh

PLEASE MARK ANSWER AS CORRECT OR HELPFUL DEPENDING ON ITS IMPACT

[Natalia11]

Hey, I have replicated all steps and this is not working for me. Please could you assist?