The quarter() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the metric.


Metric_API_Name.Dataset_API_Name.quarter(offset value)

Argument Description
offset value


An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or a function that returns a numeric value).

Where Available

  • Metric expression


Where Example(s)
Metric expression OPEX__m.target__d.quarter(-1)

Returns the OPEX target value in the time period corresponding to 1 quarter ago.


(CAPEX__m.actual__d + OPEX__m.actual__d) / (CAPEX__m.actual__d.quarter(-1) + OPEX__m.actual__d.quarter(-1))

Returns the quarter over quarter comparison of CAPEX + OPEX.


Notes: positive values look forward in time, negative numbers look backwards.


Updated on February 16, 2023

Related Articles