2 Replies Latest reply: Mar 11, 2017 8:39 AM by Ankit Gupta RSS

    Rolling 12 month Warranty cost per tractor

    Ankit Gupta

      hi,

               want to create KPIs Month \ region\ dealer \ Product wise Warranty cost per Tractor               

              Warranty Cost per tractor for any month = (Last 12 month warranty cost payments)/(last 12 tractor sales)                 

               but we need to create KPIs for region\dealer\product wise as well keeping rolling month logic in mind

               is that possible to create rolling for 4 dimensions(month\region\dealer\product) and 2 measure(warranty cost\tractor Sales)?

               any suggestions to do it in optimize way to do in script so that application not become heavy)         

        • Re: Rolling 12 month Warranty cost per tractor
          Karthik Srinivasan

          Hi Ankit,

           

          Doing it for so many dimensions in the script could turn out to be very heavy.

           

          Since, your need is for a 'KPI', this should work both from an acceptable-performance level and from maintainability perspective.

           

          rangeavg(

          count({<MonthNumber = {$(max(MonthNumber))}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),2)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),3)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),4)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),5)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),6)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),7)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),8)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),9)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),10)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),11)}>} [Warranty_Cost]),

          count({<MonthNumber= {$(max(MonthNumber),12)}>} [Warranty_Cost]),

          )

           

          Similar expression for Sales.