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,

      Date26-Nov-1227-Nov-1228-Nov-1229-Nov-1230-Nov-121-Dec-122-Dec-12
      A212542
      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

       

      Mkeari