The offsetYear() function provides the ability to offset any time series by a set number of years.
Syntax
offsetYear(integer, value)
| Argument | Description |
| integer
(required) |
The value to add to the date argument. If the value provided is not an integer, it will be rounded to the nearest integer. |
| value
(required) |
An Attribute or Metric reference to apply the defined offset to. |
Where Available
Available in Attribute and Metric expressions.
Examples
| Where | Example(s) |
| Attribute/Metric expression | offsetYear(-1, EBITDA__m.actual__d)
Provides the value for the previous year. |