✅ You are viewing documentation for the latest version of Compose SDK.
Version:
# Function runningSum
runningSum(
measure,_continuous?,name?):CalculatedMeasure
Creates a calculated measure that calculates the running total of a given measure.
The running sum is calculated using the current sort order of the query it's used in.
# Parameters
| Parameter | Type | Description |
|---|---|---|
measure | Measure | Measure to apply the running sum to |
_continuous? | boolean | Boolean flag whether to accumulate the sum continuously when there are two or more dimensions. The default value is false. |
name? | string | Name for the new measure |
# Returns
A calculated measure instance
# Example
Calculate the running sum of the total cost from the Sample Ecommerce data model across all categories.
measureFactory.runningSum(measureFactory.sum(DM.Commerce.Cost)),
Running sum values from the Sample Ecommerce data model when categorizing by age range.
| AgeRange | Cost | Running Cost |
|---|---|---|
| 0-18 | 4.32M | 4.32M |
| 19-24 | 8.66M | 12.98M |
| 25-34 | 21.19M | 34.16M |
| 35-44 | 23.64M | 57.8M |
| 45-54 | 20.39M | 78.19M |
| 55-64 | 11.82M | 90.01M |
| 65+ | 17.26M | 107.27M |