Recreating a Line Bar chart

ColinHaze
ColinHaze Member
in Charting

Hi,

I saw this chart during a demo and I think its very cool and useful. If you look at June 2024, they have a stacked bar chart. How do they accomplish this? I know you have to project the Future value out but I'm having a hard time getting them to stack. Any Advice would be great

(What I am going for)

image.png



(What I have)

image.png

Best Answer

  • GrantSmith
    GrantSmith Coach
    edited June 24 Answer ✓

    Are you currently utilizing the "Line + Grouped and stacked" chart?

    You'll also need to make sure you have your projections included in your dataset as well. You can leverage a Metric field with the type of metric which would have "Prior Year", "Current Year" or "Projected" as the values and use that as your category. Are you wanting to calculate your projections based on your data or is that done outside of Domo and you're just importing the data? You'll want to look into using Magic ETL and an Append Data tile to stack your data.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    edited June 24 Answer ✓

    Are you currently utilizing the "Line + Grouped and stacked" chart?

    You'll also need to make sure you have your projections included in your dataset as well. You can leverage a Metric field with the type of metric which would have "Prior Year", "Current Year" or "Projected" as the values and use that as your category. Are you wanting to calculate your projections based on your data or is that done outside of Domo and you're just importing the data? You'll want to look into using Magic ETL and an Append Data tile to stack your data.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColinHaze
    ColinHaze Member

    GrantSmith
    I added the projected value and couldnt figure out how to get the correct columns to stack. Apparently it has to do with the series order so I figured that out. Thank you sir for the recommendation of append.

Categories