I would like to know how i can count all records from the current date, if the current date is 2-Dec-12, to the last date in relation to each days of the last 7 days. For example data set is as below,
On the 28-Nov-12, the count of A on the 26-27 is 5. The count of A is accumulative of the previous dates counts.
How can i do this to show a bar graph like this.
I have tried but when i filter by last 7 days, i am only getting total counts for each days and not accumulated for all other days.
Mclaine, you're looking for a quick table calculation called 'Running Total' applied to COUNT(A). See attached. Hope this helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...