How do I run a simple report to see if I have any duplicates in GS?
Solved
Report on Duplicates in GS
Best answer by TMaier
The beta Data Steward module does some of this for you on Company, through fuzzy matching of some sort - I’ve seen some false positives there though.
For other objects, and more reliable results, you should create a report on the object with “Count Distinct of GSID” in Show Me and whatever your indicator of duplicates would be in Group By. Ie: for Company, if you wanted to identify duplicates based on names matching, you would have Show Me: Count Distinct of GSID, Group By: Name. From there, you’re looking for any rows with a total >1, which you can add a Filter on Measures config to target for your convenience.
+5The beta Data Steward module does some of this for you on Company, through fuzzy matching of some sort - I’ve seen some false positives there though.
For other objects, and more reliable results, you should create a report on the object with “Count Distinct of GSID” in Show Me and whatever your indicator of duplicates would be in Group By. Ie: for Company, if you wanted to identify duplicates based on names matching, you would have Show Me: Count Distinct of GSID, Group By: Name. From there, you’re looking for any rows with a total >1, which you can add a Filter on Measures config to target for your convenience.
+1this actually helped me, thanks!
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.