7 Replies Latest reply: Mar 14, 2018 4:18 AM by Manish Kachhia RSS

    Accumulated Sum - showing only 12 last months in the chart

    Tomasz Kuler

      Hi

       

      I would like to have the same result that I have in the table:

       

      13 months.JPG

       

      So the total acc. sum should still be 214. But I would like to see only 12 last months.

       

      So expected results would be (but without slider of course):

       

      13 months 12 rows.JPG

       

      Is there any method to get that result? So anything before 01/02/2014 should be added to 01/02/2014.

       

      Raw example data:

       

      load * inline [

      Date, Value

      01/01/2014, 10

      01/02/2014, 20

      01/03/2014, 10

      01/04/2014, 24

      01/05/2014, 20

      01/06/2014, 12

      01/07/2014, 15

      01/08/2014, 11

      01/09/2014, 9

      01/10/2014, 19

      01/11/2014, 20

      01/12/2014, 11

      01/01/2015, 21

      01/02/2015, 12

      ];

       

       

      THANK YOU