Limit number of Bar (Grouped Bar)
Comments
-
Unfortunately there's not a straight forward option for that in the Grouped Bar chart type. There are a couple of workarounds though.
For your series you could create a Beast Mode calculation that returned say only 3 values and grouped the remaining values into an 'Other' bucket like this:
CASE WHEN `Series` LIKE '1' THEN '1'
WHEN `Series` LIKE '2' THEN '2'
WHEN `Series` LIKE '3' THEN '3'
ELSE 'Other'
ENDYour other option is to group by your series value at the ETL level and group your values there.
Let me know if you have any other questions on this,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1 -
It would be great to have the option to choose the max # of groups and have everything else sort into "other", like the pie chart.
I'm trying to display "top x items in a given month" as a pie, then below display the trend by month. The difficulty I'm encountering with your solutions are:
1) The beastmode solution requires "top x items" to be the same every time, which they are not; and
2) The ETL solution requires groups to be the same each time I build a card based on this data. However I want certain users to see "companywide", others "by region", etc, and I don't want to create completely different dashboards based on permissions because the cards are based on different grouped production datasets. (Even if I created different dashboards based on permission levels, I still would want the "companywide" people to be able to drill/filter by region, so that's not even a solution)
Am I missing something basic? Any thoughts or recommendations? Maybe there's a different way I can display trend?
I am new to these chart types as well, I appreciate any insight!
2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K 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
- 748 Beast Mode
- 59 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 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
- 109 Community Announcements
- 4.8K Archive