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.
Comments
-
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.
0 -
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
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive