Skip to content

    • Cards, Dashboards, Stories

    Cards, Dashboards, Stories

    Displaying How far ahead or behind goals as weeks progress

    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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • 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! ✔️**

    • Member
      Answer ✓

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

    Answers

    • 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! ✔️**

    • Member

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

      goals3.gif
    • 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! ✔️**

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

    • Member
      Answer ✓

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories