tmsum
Syntax
tmsum(T, X, window)
Please see Time-Based Moving Functions (tm-functions) for the parameters and windowing logic.
Details
Calculate the moving sum of X in a sliding window.
Examples
$ tmsum(1 1 3 5 8 15 15 20, 5 2 4 1 2 8 9 10, 3)
[5,7,11,5,2,8,17,10]
$ index = take(datehour(2019.06.13 13:30:10),4) join (datehour(2019.06.13 13:30:10)+1..6)
$ data = 1 NULL 3 4 5 NULL 3 NULL 5 3
$ tmsum(index, data, 4h)
[1,1,4,8,13,13,16,8,8,11]
$ tmsum(index, data, 1d)
[1,1,4,8,13,13,16,16,21,24]