Calculates rolling or static window average
WINDOWCORR(column, window size / static window start, static window end)
column
window size / static window start
static window end
Returns a rolling or static window correlation coefficient from a given column
Argument
Description
Column on which to compute the window correlation. Must be numeric.
Size of rolling window calculation. If two window values are provided, this is the 1st row number for the static window calculation.
Optional, default is None. 2nd row number for static window calculation.
None
Window Pearson correlation coefficient(s).
Last updated 3 years ago
Was this helpful?