Skip to main content
Calculates the cumulative correlation coefficient between two columns 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 column1: INT, FLOAT, DECIMAL, NUMBER Allowed Column Types for column2: INT, FLOAT, DECIMAL, NUMBER

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 2

​
Examples

Returns the running correlation between sales and marketing spend from the first row to the current row.
Calculates cumulative correlation to track how the relationship between temperature and ice cream sales evolves over time.
  • Corr - Calculates overall correlation
  • MovingCorr - Calculates moving correlation with a window
  • CumulativeAvg - Calculates cumulative average
Last modified on March 13, 2026