Creating groups in Domo Cards

We have a quick question using the summary features of the cards. Is there a way to group data elements without creating additional columns in the datatables?
For example if I have Companies A – F in my data table and want to group them:
(Company A, Company B, Company C) = B2B
(Company D, Company E, Company F) = B2C
For summary purposes in a card. Is there a way to do this? Would I use beast mode to create a formula?
Best Answers
-
You can use a case statement in a beast mode to conditionally bucket your values
CASE WHEN `Compsny` IN ('A','B','C') THEN 'B2B' WHEN `Compsny` IN ('D','E','F') THEN 'B2C' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
You could also create groups using Segments. Here's the KB article.
https://domo-support.domo.com/s/article/4403089503383?language=en_US
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
You can use a case statement in a beast mode to conditionally bucket your values
CASE WHEN `Compsny` IN ('A','B','C') THEN 'B2B' WHEN `Compsny` IN ('D','E','F') THEN 'B2C' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
You could also create groups using Segments. Here's the KB article.
https://domo-support.domo.com/s/article/4403089503383?language=en_US
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I need some popcorn when I watch @GrantSmith and @MarkSnodgrass going to battle over these points.
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
3
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 74 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive