Contextual Accumulation for Metrics Formulas (305320) 

Contextual Accumulation for Metrics Formulas (305320) 


For use in QPR Metrics formulas, there is now a new builtin 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.