Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im dried out of ideas how to search for this.
I have a dataset with a date and a accumulative data-column, like this;
20160116, 100
20160117, 102
20160118, 105
20160119, 108
but I want it to also have a third column;
20160116, 100, 0
20160117, 102, 2
20160118, 105, 3
20160119, 108, 3
Can anyone help me?
Something like this should work:
LOAD
Date,
Amount,
Rangesum(0,Amount-Previous(Amount)) as Difference
FROM
...source...
;
Something like this should work:
LOAD
Date,
Amount,
Rangesum(0,Amount-Previous(Amount)) as Difference
FROM
...source...
;