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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive