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.

user04612

Thanks.. I think that did the trick. much appreciated!

david_cunningham

@user04612 you could use the Domo provided running total line or bar chart cards.

There is also a setting in Bar/Line charts to create running totals. You can find this in General > Number of Running Total Lines.

If neither of these options work for you. Please let me know and I can help you create a beast mode.

user04612

Am I looking in the right place? (see image)… I do not see the option: Genera > number of running line totals

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.

user04612

I see I am not using the proper chart type to get that option…. but when I try those, i do not seem to be getting what I need.

user04612

Thanks.. I think that did the trick. much appreciated!