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.