Forum Discussion

KimRavizza's avatar
KimRavizza
Qrew Cadet
3 years ago

Burnup Chart - Running Totals

Good morning,

I'm trying to create a line chart that shows a running total of the number of installs completed each week. I'm able to show the number completed each week, but I also need to show the running total.

e.g.
Week 1 completed 5, running total=5
Week2 completed 5, running total=10

Is this something I can do with a report formula?

TIA
Kim

------------------------------
Kim
------------------------------
  • The easiest way to do this is either with a summary report where you select running totals for one of the summaries or else for a chart, you can use a waterfall chart type.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • KimRavizza's avatar
      KimRavizza
      Qrew Cadet
      Mark,

      You ROCK as always! Waterfall chart is exactly what I needed!

      Thank you,

      Kim

      ------------------------------
      Kim
      ------------------------------
      • KimRavizza's avatar
        KimRavizza
        Qrew Cadet
        Here's another twist though. They want to include in this same chart, a weekly forecast with a running total as well. So each week, they forecast 5 installs will be completed.

        Week 1 forecast = 5, Running Total = 5
        Week 2 forecast = 5, Running Total =10... etc.

        This forecast number is not something that is specific to each store, so not sure how to do that.

        ------------------------------
        Kim
        ------------------------------