The yearly() function returns a time-series array of values in a yearly cadence.
When you reference a metric, it is immediately converted to the target metric cadence. This function allows you to specify an intermediate cadence to convert to.
To clarify, for example, the As Of metric expression:
AsOf metric = sumif(Initiative__t,CAPEX_Daily__m,active)
assigns a daily value to the AsOf metric (resulting in an As Of change per day).
While:
AsOf metric = yearly(sumif(Initiative__t,CAPEX_Daily__m,active))
assigns a quarterly value to the AsOf metric (resulting in an As Of change per year).
Syntax
yearly(value)
Argument | Description |
value
(required) |
An expression that returns a time-series array of values in a cadence more granular than Per Year. |
Where Available
- Metric expression
Examples
Where | Example(s) |
Metric expression | yearly(cumulative(sumif(Initiative__t,CAPEX__m,active)))
If set for an As Of metric, would apply the accumulated sum of the active Initiatives CAPEX metrics to the As Of metric on a yearly cadence.
This would return the number of days in the year. |