Remove Duplicate rows in Card
So I have this dataset which has products and their categories in the below format
Product Category
A ---------- X
A ---------- Y
B ---------- Z
B ---------- X
I am trying to build a card which shows the products filtered by categories. For example if I choose Category X and Y in the filter, it should show me one row for A and one row for B (NOT two rows for A although A is present in BOTH X and Y Category). I don't need the category column in the card but I haven't been able to find a way to just display the unique products. Could someone please help?
Comments
-
Hi @Abhigyan,
If it's a table card you're building, then I would recommend adding an aggregate column to the card (e.g. a COUNT or SUM). This should condense the duplicates. Then you can hide the aggregate column by going into Chart Properties > General > Hide Columns and typing the corresponding column number (If you want to hide the third column from the left, then enter 3).
Hope this helps!
1 -
Michelle's solution should work but I thought I would offer up an alternative that doesn't involve hiding columns.
In your case, add Product as the lone column in your table card. Then, place Product in the "Sorting" box and choose the aggregation as: Count.
From there, you can add Category as a Quick Filter and it would allow you to choose one or more categories and see all of the distinct Products.
I have attached a file as an example.
1 -
If the preview of the document doesn't load (it wasn't for me after I posted), you should still be able to dowload it by hitting the "download" button in the bottom right corner
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive