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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive