Displaying How far ahead or behind goals as weeks progress

user04612
user04612 Member
in Cards, Dashboards, Stories

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?

Goals.gif

Best Answers

  • david_cunningham
    david_cunningham Coach
    edited May 2024 Answer ✓

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

    image.png

    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.

    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • user04612
    user04612 Member
    Answer ✓

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

Answers

  • david_cunningham
    david_cunningham Coach

    @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

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • user04612
    user04612 Member

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

    goals3.gif
  • david_cunningham
    david_cunningham Coach
    edited May 2024 Answer ✓

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

    image.png

    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.

    image.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • user04612
    user04612 Member

    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
    user04612 Member
    Answer ✓

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

Categories