The day() 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.day(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.day(-90)
Returns the OPEX target value in the time period corresponding to 90 days ago.
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. |