Stack-Bar Line Graphs
Hello,
I'm trying to create a Stacked Bar Line Graph where I am able to have a the below bar graph broken out by month with an additional line graph, that graph consists of revenue numbers split by whether they fall under one of two catagories. The line graph I am trying to add would be a count of all the opportunities that are represented in these numbers.
The issue I've faced is I haven't been able to successfully recreate the below stacked bar graph when I've added in the line graph, I'll either end up with one solid bar or at best the two sections grouped next to one another. Any tips?
Answers
-
You can set your y-axis to be your total number / metric and then use two beast modes to calculate each of your two buckets for your bar, dragging each beast mode into your series section of your chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Any recs on how to structure a beast mode for that? My thinking on it was something like in an excel with an if column is X then sum but I can't quite resolve how that looks in beast mode.
0 -
Should be something like below:
CASE WHEN `field` = 'Bucket 1 Value' THEN `value` END
You can then use the aggregation options if you want to do a sum / min / max / avg. Just make sure you change the logic for your two different buckets
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive