QPR Installation Instructions

Contextual Accumulation for Metrics Formulas (305320)

Contextual Accumulation for Metrics Formulas (305320)

Previous topic Next topic  

Contextual Accumulation for Metrics Formulas (305320)

Previous topic Next topic JavaScript is required for the print function  

For use in QPR Metrics formulas, there is now a new built-in function available called "Fetch". This new function allows for the calculation of outcomes on higher level periods (e.g. Quarterly) from lower level periods (e.g. Monthly) where one needs to consider how the lower level values were calculated.

 

For example, considering the average fuel consumption of a car, measured over three months. When accumulating up to the quarterly level you cannot just take the average of the three monthly averages, but you would have to calculate the total consumption divided by the total mileage. This new function enables that.