Any suggestion for building a similar chart like this from Tableau?

user04285
user04285 Member
in Charting

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 chartThe chartMeasuresMeasures

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

  • Valiant
    Valiant Coach
    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.

Answers

  • Valiant
    Valiant Coach

    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.

     

    image.png

     

    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.

  • user04285
    user04285 Member

    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!

     

     

  • user04285
    user04285 Member

    And also, I tried recreating it but only get the columns stacked, not aligning properly like yours Smiley Sad 

    Line+Stacked.png

  • Valiant
    Valiant Coach
    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.

  • user04285
    user04285 Member

    Hi @Valiant, thanks a lot for your help. I still need to figure something else, but I think your solution provided some directions. Thanks again!

This discussion has been closed.

Categories