11 Replies Latest reply: Dec 29, 2016 7:25 AM by Rafael Salero RSS

    Cumulative Sum

    Rafael Salero

      This is my graph:

      cumulative year.PNG

       

      cumulative month.PNG

       

      At the moment I am having trouble with the measure "Total Pendente". It´s suppose to sum the number of tickets in state vPendentes of previous months and years.

      If in 2014 we close the year with 4 tickets "Pendente" on Jan 2015 it should be: 4 of 2014 plus 1 of Jan 2015.

       

      Another ex: if i select Mar 2016 it should sum all month before Mar 2016 and Mar 2016 included;

       

      It is still important that the graph correspond to selections like client (its on the same table).

       

       

      Here is the code for Total Pendente at the moment:

      RangeSum(

        Above(

          Count(

              {$<status_name = {$(vPendente)},

                  Month,

                  Year>}

              [ticket_id]),

          0,

          RowNo())

      ) * Avg(1)