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

Running totals starting from previous total

Peter Connolly Jul 26, 2012 8:01 AM

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

Emiliano Colosimo Jul 27, 2012 2:35 AM (in response to Peter Connolly)

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.
Like Show 0 Likes(0)

Actions
2. Re: Running totals starting from previous total

Peter Connolly Aug 27, 2012 8:00 PM (in response to Peter Connolly)

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?
Like Show 0 Likes(0)

Actions
3. Re: Running totals starting from previous total

Shawn Wallwork Aug 27, 2012 9:04 PM (in response to Peter Connolly)

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:
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Running totals starting from previous total

1. Re: Running totals starting from previous total

2. Re: Running totals starting from previous total

3. Re: Running totals starting from previous total

Actions

More Like This