We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Best way to show accumulate data in Line Graph?

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

1 Reply

SJ Sumathi Jayaraj Syncfusion Team February 8, 2016 03:22 PM UTC

Hi Markus,

Thanks for contacting Syncfusion support.

We are able to achieve your requirement by manipulated the accumulated values using movement values. We have prepared a sample and it can be downloaded in the following location.

Sample : LineGraph

Regards,
Sumathi J

Loader.
Up arrow icon