groupArrayMovingSum

Calculates the moving sum of input values.

The function can take the window size as a parameter. If left unspecified, the function takes the window size equal to the number of rows in the column.

Arguments

• numbers_for_summing — Expression resulting in a numeric data type value.
• window_size — Size of the calculation window.

Returned values

• Array of the same size and type as the input data.

Example

The sample table:

The queries: