Dynamic series line bar
It's a regular frustration for me that I can't create a line bar graph which stacks dynamically based on a dimension without using multiple beastmodes.
For example I want to include a target value as a line, and then actuals stacked by type over time. This has been raised before here: https://dojo.domo.com/discussion/comment/23168#Comment_23168)
The best I can do is a grouped bar using categories:
But this is quite ugly and difficult to read.
Anyways, just wanted to raise the question again in case I'm missing a solution that has since been implemented?
Answers
-
Hi @LCash ,
It shouldn't be difficult to do what you are trying to do.
Make sure to select the correct Chart Type and also you might need to create a beastmode to use as a sorting option to make the 'Forecast' series be the first one so that it plots as a line and the rest of series get stacked in a bar.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
@Godiepi thank you! That looks like what I need but I'm struggling to understand how you've implemented the solution. What's confusing me is what's generating the bar values as it all seems to be coming from a single table column?
If that's right it doesn't quite achieve what I want as the forecast is split out as a separate column in my dataset:
Does your solution rely on data which looks like the below?
If it does then I understand it and it definitely points to a solution at the processing level, but I was hoping to be able to track two metrics and split just one of them by a category.
0 -
@LCash Oh, I see what you are saying
so , with your dataset being formated as the first table in your post, you will need to
1) bring forecast column into the Y-axis (sum Aggregation)
2) for the 'Series' part you will have to add beastmodes for each Product doing the sum of metric like this below
Prodcut X: sum(case when `category` = 'x' then `metric` else 0 end) Product Y: sum(case when `category` = 'y' then `metric` else 0 end) Product Z: sum(case when `category` = 'z' then `metric` else 0 end)
3) with the 3 beastmodes , drag and drop each on the Series, you can add as many as you want to the right side of each. unfortunately this is the only way I see it possible without a flow... I hope the number of products isn't a lot since you will need to create 1 per product
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
@LCash i wouldn't recommend it, but you could put your product actuals into separate columns using PIVOT in Magic 2.0
it may seem counter intuitive but stacking the data (date, category, metric) would actually be the best solution , because if you had data that was not preaggregated (if you had multiple product x sales in one day) then you don't need your data to be compressed to a specific granularity as you do if your data is formatted (date ,category, actual,forecast)
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive