Computes the correlation coefficient between two columns. Source values can be of Integer or Decimal type.
The correlation coefficient measures the relationship between two sets of values. You can use it as a measurement for how changes in one value affect changes in the other.
Output: Returns the correlation coefficient between the values in the
initialInvestment column and the
correl(function_col_ref1,function_col_ref2) [group:group_col_ref] [limit:limit_count]
|function_col_ref1||Y||string||Name of column that is the first input to the function|
|function_col_ref2||Y||string||Name of column that is the second input to the function|
For more information on the
limit parameters, see Pivot Transform.
Name of the column the values of which you want to calculate the correlation. Column must contain Integer or Decimal values.
|Required?||Data Type||Example Value|
|Yes||String (column reference)|