Only Show Unique Entries in Text Field
I have a dataset that has a column with the agent name that entry belongs to. There are dozens of repeats for each agent, as they deal with multiple businesses. Is there a way in a table card to have one of the columns only show the unique entries in that column, ie only show each agent once? I don't want to remove duplicates, as I need to run calculations on the data, but I just need to display each agent name once in a column on a table. Is there any way to do that?
Best Answer
-
Yes you can, but if you are showing a lot of columns it could be difficult. If any single column is aggregated then the others will only show unique values.
To test it simple just add two columns such as agent and count of `somethingelse`
If this is your data:
Agent Amount Product
Jim 50 Box
Jim 60 Bag
Jim 40 Box
Jenny 90 Box
Jenny 80 BoxThe simplest card will look like this:
Total = SUM(`Amount`)
Agent Total
Jim 150
Jenny 170It only shows the Agent once because of the aggregated `Total` column. However if you add other columns they will affect it. If the card shows `Product` it will look like this:
Agent Product Total
Jim Box 90
Jim Bag 60
Jenny Box 170Jim shows twice because the combination of Jim+Product is unique. The table card will make sure all unique values are shown.
You'll have to play with it to get the list you want but if the only non-aggregated column is `Agent` then you should only get each agent's name once.
Extra Thought:
In a table card you have the ability to hide columns. If you don't want the second column to show, so just a list of Agents only with no other columns, then you can hide it via Chart Properties > General > Hide Columns
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Yes you can, but if you are showing a lot of columns it could be difficult. If any single column is aggregated then the others will only show unique values.
To test it simple just add two columns such as agent and count of `somethingelse`
If this is your data:
Agent Amount Product
Jim 50 Box
Jim 60 Bag
Jim 40 Box
Jenny 90 Box
Jenny 80 BoxThe simplest card will look like this:
Total = SUM(`Amount`)
Agent Total
Jim 150
Jenny 170It only shows the Agent once because of the aggregated `Total` column. However if you add other columns they will affect it. If the card shows `Product` it will look like this:
Agent Product Total
Jim Box 90
Jim Bag 60
Jenny Box 170Jim shows twice because the combination of Jim+Product is unique. The table card will make sure all unique values are shown.
You'll have to play with it to get the list you want but if the only non-aggregated column is `Agent` then you should only get each agent's name once.
Extra Thought:
In a table card you have the ability to hide columns. If you don't want the second column to show, so just a list of Agents only with no other columns, then you can hide it via Chart Properties > General > Hide Columns
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Yes you can make the name of the agent show only once in a table card by adding subtotal rows in the Chart properties and telling Domo to only "Show Group Name Once"
See screenshot below
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive