12 Replies Latest reply: Dec 15, 2016 1:36 PM by Sunny Talwar RSS

    Cummulative measure

    Rafael Salero

      Hello,

      question.PNG

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      I want to create a measure T.Pendentes (the red one) that is the sum of the mesasure Pendentes (the yellow) on the previous years.

      So it should be:

           68 on 2014

           68+132= 200 on 2015

           68+132+292=492 on 2016.

       

      I don´t know if it help but at the moment the formula for the yellow measure is:

        Count(

                {

                    $<status_name={

                        'new',

                        'open',

                        'pending reminder',

                        'pending auto close+',

                        'pending auto close-',

                        'approved',

                        'Waiting customer action',

                        'Waiting implementation Date',

                        'Verification in progress'

                    }>

                }

            [ticket_id])