quarter()

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

Syntax

Metric_API_Name.Dataset_API_Name.quarter(offset value)

Argument Description
offset value

(required)

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

Examples

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