Skip to content

CumulativeAvg

Calculates the cumulative average of values from the first row up to the current row within a partition.

Category: window

Syntax:

CumulativeAvg([column])

Returns: Float

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
column column ✓ Yes The numeric column to calculate cumulative average for

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

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

CumulativeAvg([Sales])

Returns the running average of sales from the first row to the current row.

CumulativeAvg([Revenue])

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