3 Replies Latest reply on Aug 27, 2012 9:04 PM by Shawn Wallwork

# Running totals starting from previous total

I have a range of data which covers May - July.

When I graph the whole range, the figures are perfect - start from 0 on May 1st, up to 221 on July 27.

When I graph the 'Month to date', which is more likely to be of use in some circumstances, it shows the range as from 3 on July 1st to 95 on July 27. This is fine for some purposes, but generally we just want to see the right-hand end of the YTD graph; i.e, I want July 1st to show me '129', and July 27 to show me '221'. The following image shows the data I'm getting now.

I'm only a beginner, so I'm sure there's something simple I need to do to fix this calculation!

Thanks!

Peter Connolly

• ###### 1. Re: Running totals starting from previous total

Hi Peter,

You could edit the x-axis (right click on axis -> Edit Axis) and set a Fixed range for the month of July. This means that you are not filtering out the previous data but just selecting what to view.

• ###### 2. Re: Running totals starting from previous total

So the answer by Emiliano is correct as far as it goes, but I've just had the question thrown back at me by one of our users. He is using the Reader, and wants to zoom in on the data using the Quick Filter options. Set to 'This Year', we see all the data. Set it to this week, and it shows me only the counts for this week - starting from zero. This is of no use to him (or me, or anyone). It would be fine to have that as an option, but we're often wanting to see very specific details about the last week - including a running total, starting at the start of that time period at the correct figure - so showing me 100 - 150, for example, instead of 0 to 50.

Any suggestions?

• ###### 3. Re: Running totals starting from previous total

Peter, you know you can literally zoom in on any chart just like a map, right? (Zoom controls are turned off by default in charts.) Rt-click 'Show Controls'. Then this:

Turns into this: