Line Chart DateTime Axis Accumulation

Question

Hello,see this codepen:priceless-star-zbbn3 - CodeSandboxWhat I would like to achive is, to have one value on the x-Axis per month with an accumulation of the y-Values, here each month one accumulated value (if there are more that 1 values in the month).Is there a way to achieve that? Like a grouping or accumulation on time-ranges?Thanks a lot!Martin

Durga Gopalakrishnan · Accepted Answer

Hi Martin,

As of now, we don't have option to find same values on x values and sum up the y values automatically. You can use chart load event to find duplicates of x from array of object and perform sum with y values, then finally pass a single object in that data source array.





<ejs-chart :load='onChartLoad'>export default Vue.extend({methods: {      onChartLoad: function(args){     //... }    }})
Please revert us if you have any concerns.

Regards,
Durga G

Durga Gopalakrishnan · Answer

Hi Martin,

Greetings from Syncfusion.

We suggest you use DateTimeCategory axis with isIndexed as true to acheive your requirement. We have attached modified sample for your reference. Please check with below UG links and sample.

UG Links : 
https://ej2.syncfusion.com/vue/documentation/chart/category-axis/#indexed-category-axis
https://ej2.syncfusion.com/vue/documentation/chart/date-time-axis/#datetimecategory-axis

Sample : https://codesandbox.io/s/mystifying-knuth-70qej

Please revert us if you have any concerns.

Regards,
Durga G

Martin Frühmorgen · Answer

Hello,thanks for the updated codepen.Unfortunately that's not what I want to achieve.I would like to see in this example the accumulated values (summed up) of every month.This means, f.e.SeriesData March 2016 has value 6.3 + 10.3 = 16.6April 2016 has value 13.3and so onSeriesData1March 2016 has value -5.3April 2016 has value 1 + 10 = 11and so onAny way to achieve this without doing the calculation on the arrays?Thanks!Martin