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

Syntax 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

Returns the OPEX target value in the time period corresponding to 90 days ago., today())

Returns the Total Value actual value in the time period corresponding to the last reporting date.

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


Updated on February 7, 2023

Related Articles