Forum Discussion

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

reports and charts

Qrew Cadet

Mark,

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

Thank you,

Kim

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

Qrew Cadet

3 years ago

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

MarkShnier__You
Qrew Legend
3 years ago
That makes it more complicated. An expedient solution would be a button to land the user on a page which has two separate waterfall charts and then the users can kind of visually compare.

But I think if do you want it all on one graph then I think it can be done by having a table of weeks and then you would have to have a two formula queries to calculate your running totals. The syntax for those formulas is a little more complicated so I'm not sure I could just whip that up quickly on this community forum. If you want it badly enough you would have to contact me directly for some one-on-one consulting assistance or else hope that someone else is willing to help you on this forum with the formulas for those Formula Queries.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- KimRavizza
  Qrew Cadet
  3 years ago
  Thanks Mark,
  
  I'm meeting with the users tomorrow. Will reach out if we can't figure it out.
  
  ------------------------------
  Kim
  ------------------------------