Output: Generates the new column, which contains the rolling count of non-null values of the current row and the two three previous row values in the
Output: Generates the new column, which contains the rolling count of non-nulls from the two three previous row values, the current row value, and the two rows after the current one in the
Integers representing the number of rows before or after the current one from which to compute the rolling function, including the current row. For example, if the first value is
5, the current row and the four five rows after before it are used in the computation. Negative values for
k compute the rolling average from rows preceding the current one.
rowBefore=10generates the current row value only.
rowBefore=-1uses all rows preceding the current one.
rowsAfteris not specified, then the value
- If a
groupparameter is applied, then these parameter values should be no more than the maximum number of rows in the groups.