Rolling 12 month Warranty cost per tractor

[Anonymous]

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)         

[karthiksrqv]

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.

[Anonymous]

Thanks for reply, but I need to create month wise bar chart as

so in this Jan -17 bar will represent Avg Warranty Cost as -- last 12 month Cost / Last 12 Month Sales