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:
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?
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
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.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
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 yours0
- 7.6K All Categories
- 914 Connectors
- 241 Workbench
- 471 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 24 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 18 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部