0 Replies Latest reply: Oct 9, 2014 5:41 AM by Kim Giolo RSS

    How to get last row value when using cyclic groups

      I would like to create a bar chart that has as time dimension a cyclic group Day/Week/Month and as expression something that shows the number of total members at the end of the time period, not the average or sum , but the last row.

      For example if Day is selected

       

      DayNumber of Members
      10.04.1444776
      11.04.1444815
      14.04.1444854
      15.04.1444887
      16.04.1444921
      17.04.1444946
      18.04.1444946
      21.04.1444946
      22.04.1444952
      23.04.1444950
      24.04.1444962
      25.04.1444989
      28.04.1445000
      30.04.1445073
      01.05.1444920
      02.05.1444945
      05.05.1444969
      06.05.1445002
      07.05.1445056
      08.05.1445120
      09.05.1445139
      12.05.1445139
      13.05.1445179
      14.05.1445225
      15.05.1445247
      16.05.1445225
      19.05.1445309
      20.05.1445348
      21.05.1445369
      22.05.1445389
      23.05.1445410
      26.05.1445455
      28.05.1445455
      29.05.1445455
      30.05.1445455
      02.06.1445282
      03.06.1445443
      04.06.1445443
      05.06.1445442
      06.06.1445502
      09.06.1445502
      10.06.1445510

       

      if Week is selected then I have

       

      WeekNumber of Members
      2014/1544815
      2014/1644946
      2014/1744989
      2014/1844945

       

      that is for each week I have the number of members of the last day of that week

       

      if Month is selected then I have

       

      MonthNumber of Members
      avr. 201445000
      mai 201445455
      juin 201445510

       

      that is for each month I have the number of members of the last day of that month.

       

      Since I work with business days, last day of week or month for me is the last data point I have for that week or month not the calendar day.

       

      Does anyone know how to make such a chart?