How do I remove duplicate rows in a card drilldown?
I have a card that is created by counting IDs and when I drill down into the card, it shows all the rows for that ID. I just want to show unique rows for a user ID. Attached is the screenshot for my data.
I want my drill down to look like this.
Basically, I want to remove the duplicates in the drill down. Is there any way to do it in the card using beast modes?
Thanks.
Best Answer
-
Add another column that aggregates a field by using the count or sum, for example, and it will remove the duplicates. You can do this by dragging another field over and then click the pencil icon next to it and choose one of the aggregation options. Make sure you don't have anything that is in the sorting properties
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Add another column that aggregates a field by using the count or sum, for example, and it will remove the duplicates. You can do this by dragging another field over and then click the pencil icon next to it and choose one of the aggregation options. Make sure you don't have anything that is in the sorting properties
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thank you @MarkSnodgrass this worked.
0 -
Can someone please elaborate on this? I still can't find a way to remove duplicate rows.
Thanks in advance.
0 -
@SaloniShah post a picture of what you're currently doing / strugglign with.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive