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