How to remove duplicate records from the drill down view


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.



Best Answer