# Displaying How far ahead or behind goals as weeks progress

Options
Member

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?

• Coach
Options

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.

David Cunningham

** Did this solve your problem? Accept it as a solution! ✔️**

• Member
Options

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

• Coach
Options

@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.

David Cunningham

** Did this solve your problem? Accept it as a solution! ✔️**

• Member
Options

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

• Coach
Options

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.

David Cunningham

** Did this solve your problem? Accept it as a solution! ✔️**

• Member
Options

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.

• Member