Burnup Chart - Running Totals

Question

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=5Week2 completed 5, running total=10Is this something I can do with a report formula?TIAKim------------------------------Kim------------------------------

markshnier__you · Answer

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

Mark,You ROCK as always! Waterfall chart is exactly what I needed!Thank you,Kim------------------------------Kim------------------------------

kimravizza · Answer

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

That makes it more complicated.&nbsp; An expedient solution would be a button to land the user&nbsp; on a page which has two separate waterfall charts and then the users can kind of visually compare.&nbsp;&nbsp;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.&nbsp; 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 · Answer

Thanks Mark,I'm meeting with the users tomorrow. Will reach out if we can't figure it out.------------------------------Kim------------------------------

Forum Discussion

Burnup Chart - Running Totals

5 Replies