Query cumulative sum
Given the following input table:
_time | _value |
---|---|
0001 | 1 |
0002 | 3 |
0003 | 4 |
0004 | 7 |
The examples below use the example data variable.
Calculate the running total of values
aggregateWindow()
expects an aggregate function that returns a single row for each time window. To use with aggregateWindow
, use sum
in , then calculate the running total of the aggregate values with cumulativeSum()
.