Recreating a Line Bar chart

ColinHaze

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)

(What I have)

GrantSmith

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.

GrantSmith

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.

ColinHaze

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.