13 Replies Latest reply: Dec 13, 2013 4:33 AM by Massimo Grossi RSS

    Cumulative count for chart

    Paulus Indra Salim

      Hi, I have a question about count a dimension.

      Here is the sample :

       

      IDDate
      A1-Jan
      B1-Jan
      C1-Jan
      B2-Jan
      C2-Jan
      C2-Jan
      D2-Jan
      C3-Jan
      E3-Jan

       

      There are 5 IDs : A,B,C,D,E

       

      I want to make chart that show :

      1 Jan has 3 IDs ( That 3 IDs from count distinct 1 Jan : A, B C)

      2 Jan has 4 IDs ( That 4 IDs from count distinct 1 Jan to 2 Jan : A, B C,D)

      3 Jan has 5 IDs ( That 5 IDs from count distinct 1 Jan to 3 Jan : A, B C,D,E)

       

      Does someone has any idea what kind of expression I could use for this case?

      Thanks.