Any suggestion for building a similar chart like this from Tableau?
I have this chart created in Tableau, but now I need to recreate this chart in Domo.
The chart will have two categories and two measure names, as well as an x-axis and two y-axes, like this:
The chartMeasures
I tried the line + grouped bar but it doesn't seem to completely recapture this card in Tableau.
Any suggestions as how to make this as similar to the original one?
Thanks!
Best Answer
-
Ok, so I'm going to assume that for the current month you're using your Forecasted Production and anything prior to that is actual.
Forecasted Production beastmode:
CASE WHEN `Date` >= DATE_FORMAT(Current_Date(), '%Y-%m-01') THEN `forecasted_production` END
Actual Production beastmode:
CASE WHEN `Date` < DATE_FORMAT(Current_Date(), '%Y-%m-01') THEN `actual_production` END
This will keep the bars from stacking on each other. Let me know if you need anything else.
0
Answers
-
So you can recreate that using the Line + Stacked Bar. I did a quick mock-up below. The way to do this is to set your Date as your X-axis and then break it into 4 measures using BeastModes. (You can do this with Case When statements, let me know if you'd like more detail around this).
Once you have the 4 measures, add the 2 lines first. Under Chart Properties -> General and set the 'Series on Left Scale' to 2. Then add you bars for production.
The rest is just formatting. Let me know if you have any questions.
Sincerely,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Hi @Valiant!
Thanks so much for your reply! Your chart actually looks close enough to what I need, but can you clarify this:
"...The way to do this is to set your Date as your X-axis and then break it into 4 measures using BeastModes."
Can you please let me know how to do this? Since I am not at all familiar with this yet.
Thanks again so very much!
0 -
And also, I tried recreating it but only get the columns stacked, not aligning properly like yours
0 -
Ok, so I'm going to assume that for the current month you're using your Forecasted Production and anything prior to that is actual.
Forecasted Production beastmode:
CASE WHEN `Date` >= DATE_FORMAT(Current_Date(), '%Y-%m-01') THEN `forecasted_production` END
Actual Production beastmode:
CASE WHEN `Date` < DATE_FORMAT(Current_Date(), '%Y-%m-01') THEN `actual_production` END
This will keep the bars from stacking on each other. Let me know if you need anything else.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 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
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive