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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive