FunctionsTime Series

group_array_moving_sum

Builds a moving-sum series over the aggregated numeric sequence and returns it as a JSON array string. The optional second argument sets the moving window size.

group_array_moving_sum(…) → String

Kind · aggregate

Builds a moving-sum series over the aggregated numeric sequence and returns it as a JSON array string. The optional second argument sets the moving window size.

Part of the Time Series family.

group_array_moving_avg

Builds a moving-average series over the aggregated numeric sequence and returns it as a JSON array string. The optional second argument sets the moving window size.

running_difference

Computes the difference between each value and the previous value in input order. The first non-NULL value yields 0 in this implementation.