Description
Cumulates a Metric defined on a Time Dimension (Day or Month) and resets the cumulation each quarter.
Equivalent of: CUMULATE(Metric, Month, Month.Quarter) or CUMULATE(Metric, Day, Day.Quarter)
Syntax
QUARTERTODATE(Metric M, Aggregation])
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Metric (required) | Number | Time Dimension more granular than Quarter | Number to cumulate. |
| Aggregation (optional) | Aggregation | Available values: SUM, AVG, MIN, MAX. By default, the aggregation is SUM. |
Returns
| Type | Dimensions |
|---|---|
| Number | Same Dimensions as argument Metric |
Examples
| Formula | Description |
|---|---|
|
| Cumulates the Metric ‘Quantity Sold’ (each day/month is added to the sum of the previous day/month and reset when the quarter changes). |
See also
Related articles: CUMULATE, MONTHTODATE , YEARTODATE
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
