Calculates the cumulative count of values from the first row up to the current row within a partition.
Category: window
Syntax:
CumulativeCount([column])
Returns: Integer
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
column | column | ✓ Yes | The column to count values for |
Validation
- Minimum parameters: 1
- Maximum parameters: 1
Examples
CumulativeCount([Order_ID])
Returns the running count of orders from the first row to the current row.
CumulativeCount([Customer_ID])
Calculates cumulative count of customers, useful for tracking total customer interactions over time.
Last modified on March 13, 2026