This content has been marked as final. Show 3 replies
As for your data the following will apply:
date value RangeSum(value;peek(value)) as CumulativeSum peek(CumulativeSum) 2018-01-01 10 10 - 2018-01-02 5 10+5 10 2018-01-03 2 15+2 15 2018-01-04 7 17+7 17
It's a visual interpretation of what it will do.
Just don't forget to order your data by date field, like:
test: Load * Inline [ date,value 2018-01-01,10 2018-01-02,5 2018-01-03,2 2018-01-04,7 ]; finalData: Load *, RangeSum(value,Peek(CumulativeSum)) as CumulativeSum Resident test order by date; drop table test;
or esle the peek function will get quite weird behavior on the data.
Hope it helps