The year() 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.year(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.year(-1)
Returns the OPEX target value in the time period corresponding to 1 year ago.
Returns the year over year comparison of CAPEX + OPEX.
Notes: positive values look forward in time, negative numbers look backwards. |