How do I remove duplicate rows in a card drilldown?
bjain7
⚪️
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.
0
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
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Thank you @MarkSnodgrass this worked.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有