How to remove duplicate records from the drill down view

Raj_Rawat_84 · June 28

Hi Community

We have 6 months data in which we have some duplicate emails available, however we have created a beast mode to show the unique count in the chart but when we go to the drill down we are getting all the records with duplicate records too. So is ther any way we can create a beast mode where in drill down we can get only the Unique email address.

We use Salesforce as the data source and the data set powers up other cards where we need the duplicate records too.

The Beast mode we are using is :COUNT(DISTINCT Email)

Thanks in advance for your help.

Raj

ColemenWilson · June 28

You can create a custom drill path instead of going to the default table view. In your custom drill path, just aggregate a value with email address as the first column and there won't be duplicates. https://domo-support.domo.com/s/article/360042924094?language=en_US

ColemenWilson · June 28

You can create a custom drill path instead of going to the default table view. In your custom drill path, just aggregate a value with email address as the first column and there won't be duplicates. https://domo-support.domo.com/s/article/360042924094?language=en_US

Raj_Rawat_84 · July 2

Hi @ColemenWilson

Thank you so much for the solution it worked for us

How to remove duplicate records from the drill down view

Best Answer

Answers

Categories