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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive