Stacked Bar Chart Sorting Incorrectly
I have a stacked bar chart and would like to sort it in decending order based on the sum of the metric used in the chart. Instead of sorting by the total for the y axis category, it's sorting based on the total for category/series combination. The screenshot below shows an example where the sorting only factors the y axis category/series with the greatest value instead of the y axis category total across all of the series'
Comments
-
I'm not able to see your image, but based on description I believe I had the same issue and found a cheat solution that worked for me. Rather than using a single series to define my "stack", I used Beast mode to create independent results for each possible series category, and brought in those multiple pre-aggregated results. In this way i was still able to sort the stack based on the total population, and controlled the stack order based on the order in which i brought in each Beast Mode calc.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1
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