Product Tour
forums
Use these forums to ask questions and discuss Tableau.
Page Shelf - Is there a way to show cumulative data?
I have a challenge for you, I've racked my brain and have come up short so far. With the paging function, is there a way to show a 'cumulative' set of pages (where more and more records are filtered in at each page)? For example, the first page whould show all records where date is less than X, the second page would show all records where the date is less than X+7 days, the third would show all records where the date is less than X + 14 days, and so on. This would show cumulative growth as opposed to 'slices'.
I've been trying to think creatively with formulas (maybe using a DateDiff as an inner function with some other function around it..), but can't quite get it. Thought there may be others more clever out there that already have it worked out.
Subscribe to the comments on "Page Shelf - Is there a way to show cumulative data?"
Comments
An excellent question. I have two answers for you: if you want to page #1 to show a certain set of marks, and then page #2 to show those marks plus a new set of marks, then Tableau 2.0 cannot currently do that. If you want page #1 to show marks that express, for example, SUM(Sales) in each market for the first month, and page #2 to show sum(sales) for the first two months, etc., then Tableau can do that with its Table Calculation feature.
What I did is this:
1. Build my view (Market v. SUM(Sales))
2. Add my date field to the page shelf (I used MY(Date))
3. Change SUM(Sales) to a "running total" Table Calculation, with Date as its "running within" field.
Enjoy!