Hello,
I'm not sure if this is the right place to post this question but alas the gods are with those who dare.
I've got a database table which among other columns has two named 'DTS' and 'Movement'.
DTS
| Movement
|
01.01.2016 12:00
| +6.5
|
02.01.2016 20:00
| -4
|
03.01.2016 13:45
| +4.4
|
04.01.2016 13:45
| +10
|
...
| ...
|
Now I want to visualize this information in a Line graph, The X Axis should be the 'DTS'-Column but the Y Axis should be the sum of the values of the movement column up to the DTS.
For example
X: 01.01.2016 12:00 Y: 6.5
X: 02.01.2016 20:00 Y: 2.5 (6.5 - 4)
X: 03.01.2016 13:45 Y: 6.9 (6.5 - 4 +4.4)
X: 04.01.2016 13:45 Y: 16.9 (6.5 - 4 + 4.4 + 10)
...
Is there's an elegant way to solve this?
Best Regards
Markus