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?