How can I combine multiple data points from the same data column into one new data point.
Hello all, and thank you for any advice. I am trying to build out a card that combines multiple different values into one on a card. For example; say a column is tracking colors. I have values of red, blue, green, white, black, yellow. Could I create a card that shows black as one value, then combine all of the other colors to be “other colors” so there would only be two data points for that column instead of all of the different colors? Thanks!
Best Answer
-
Yes. You can use a beastmode to accomplish this:
CASE WHEN `Color` = 'Black' THEN 'Black' ELSE 'Other Colors' ENDHere is a good video to help if you've not used beastmodes before:
If I solved your problem, please select "yes" above
1
Answers
-
Yes. You can use a beastmode to accomplish this:
CASE WHEN `Color` = 'Black' THEN 'Black' ELSE 'Other Colors' ENDHere is a good video to help if you've not used beastmodes before:
If I solved your problem, please select "yes" above
1 -
Thanks again @ColemenWilson - as is for my other post you helped out with, I won’t be able to try this until tomorrow (I thought it would take longer to get a response!) when I am back at my desk, but I will try it and come back with an update tomorrow. I really appreciate the responses, so thank you.
0 -
@ColemenWilson This worked perfectly - thank you.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 745 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 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