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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive