how to get distinct emails

Reply
Yellow Belt

how to get distinct emails

I have create a card to show the monthly subscriber, I then wanted to do a drill down to show the exact emails for the subscribers.  However, there are dublications in the emails, how to only show the distinct emails?  

 

Thank you.

 

 

Black Belt

Re: how to get distinct emails

You will need to bring in some kind of an aggregate column to your table.  Something like Count of Clicks.  This will agregate your table to only show unique emails.  

 

If you want me to get more specific, I will need to understand more of what your data looks like and how you are trying to display it.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Yellow Belt

Re: how to get distinct emails

Hi, Superman,

 

Since this is a drill down card to show who subscribed to our mailing list, I realy do not want to show anything else.  If I add another aggregated fiedd in a table chart, can I somehow hide that column from viewing?

 

Thank you.

 

Olivia

 

 

Announcements
Dojo Day is Coming! Mark your calendars for May 30th 0900-1700 MST Click here for more information