Handling report grouping

Good morning Dojo!
I am in the process of building a dashboard of our ticket system. One chart I would like to make is a chart that shows general types of ticket and their volumes. To keep things simple I would like to reduce the number of different ticket types in the dataset from 30 to about 5. Now I know there are multiple ways to do this (lookup tables, beast mode calculations, MYSQL statements etc.) however I would like to hear from yourselves what method will save me future headaches and is the easiest for me and my colleagues to maintain.
Thanks in advance.
Dave.
Best Answer
-
If the categorization grouping is something that is going to be used in several places and not just one card, I would recommend doing this at the dataflow level. This way you have one place to make changes if necessary and you can also carry these groupings through to other datasets as you make them in the future.
1
Answers
-
If the categorization grouping is something that is going to be used in several places and not just one card, I would recommend doing this at the dataflow level. This way you have one place to make changes if necessary and you can also carry these groupings through to other datasets as you make them in the future.
1 -
I assume the the reverse holds true (i.e. if the grouping is used on one card, build it into the card)?
0 -
My approach of reducing to fewer categories using SQL statement(case when and wild card).
Like mentioned, you need to build it at the dataflow level so that you can add it to the filter panels.
Thanks
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 21 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 414 Distribute
- 122 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive