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