Displaying How far ahead or behind goals as weeks progress

user04612

I have an etl that is joining a google sheet that has weekly goals, to a dataset that have the actual weekly sales. I am currently showing the week by week results in a grouped bar card… each week side by side, actuals to goals. (see image)

Is there a way with the data I have, to show how far ahead or behind we are up to the given week. Example we are in week 7, and I'd like to show the cumulative Sales for those 7 weeks vs the cumulative Goal for the seven weeks, and have that update each week to see how we are doing w/o having too add them up from the grouped bar chart?

david_cunningham

The easier approach is to use Domo's built in chart type "Running total grouped bar".

If you want to use the chart properties option, you'll need to use a line/bar combo chart. Then you can set the series on left scale to 0 and set number of running bars to 2. I don't see much advantage to this approach given your use-case. This is better if you want to have both individual and running total on the same chart.