Function Index


Calculates the correlation coefficient of the column up to and including the current value.


CumulativeCorr(<field 1>,<field 2>)

field1 (required) The column representing the dependent data.

field2 (required) The column representing the independent data.

NOTE: Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.


CumulativeCorr([Population 2010], [Population 2000])
  • For each pair of values in [Population 2010] and [Population 2000], calculate the correlation coefficient the group of values containing that pair of values and all the preceding values.