Skip to main content
Calculates the cumulative average of values from the first row up to the current row within a partition. Category: window Syntax:
Returns: Float Context Filtering: ✓ Yes

​
Parameters

Allowed Column Types for column: INT, FLOAT, DECIMAL, NUMBER

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Returns the running average of sales from the first row to the current row.
Calculates cumulative average revenue, useful for tracking average performance over time.
  • CumulativeSum - Calculates cumulative sum
  • MovingAvg - Calculates moving average with a window
  • Avg - Returns the overall average
Last modified on March 13, 2026