1 Reply Latest reply: Feb 10, 2012 7:11 AM by Stefan Wühl RSS

    Accumulation question

      Hello,

      I want to create a chart that uses accumulation (I assume in some way).

      This is what I want the outcome to look like:

      DATE                   Total      Acc per month      Acc per year

      2012 jan-01          100        100                       100

      2012 jan-02          120        220                       220

      2012 jan-03           80         300                       300

      ...

      2012 jan-31          110        1300                      1300

      2012 feb-01           90         90                         1390

      2012 feb-02          130        220                        1610

      ...

       

      I.e. for each month I want the accumulation to start from scratch.

      But I want to display the indivudual dates in the month

       

      When experimenting with the accumulation settings in the expression I can not get it to start from scratch each month.

      Instead it just accumulates the number of steps back that I set.

       

      Is this possible?

       

      br

      Martin