1 Reply Latest reply on Dec 2, 2012 9:33 PM by Shawn Wallwork

    Counting records

    Mclaine keari

      Hi all,

      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,

      Count A235101416

      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.


      Please help