The quarterly() function returns a time-series array of values in a quarterly cadence. It can only be applied to As Of, Per Day, Per Month, and Per Quarter metrics.
Note: while allowed, the assignment of this function to a per quarter metric would have no effect since the per quarter metric would inherently be translating the values to the per quarter 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 = quarterly(sumif(Initiative__t,CAPEX_Daily__m,active))
assigns a quarterly value to the AsOf metric (resulting in an As Of change per quarter).
Syntax
quarterly(value)
| Argument | Description |
| value
(required) |
An expression that returns a time-series array of values in a cadence more granular than Per Quarter. |
Where Available
- Metric expression
Examples
| Where | Example(s) |
| Metric expression | quarterly(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 quarterly cadence. |