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 [, 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. |
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!