Getting aggregated series data

[Bob]

We have a stacked area or line chart in which the categoryAxis is a date.  In each series, values are aggregated (summed).

We are wanting to implement an export to CSV of the data which makes up the displayed chart. I've looked through all of the chart options, but cannot find a way to get those aggregated series values. 

Is there any way to do this without having to write my own aggregation logic?

 

 

[Tsvetomir]

Hi Robert,

In general, the engine used for the export to SVG exports "what it sees". Therefore, having aggregated values in the series should be exported without any additional intervention. Check out the following example that implements Date category axis along with aggregated series:

https://dojo.telerik.com/OQifexIN

Let me know in case the scenario you are working on has additional logic that is implemented.

 

Regards,
Tsvetomir
Progress Telerik

[Bob]

I'm not interested in an SVG image.

I want *CSV*, comma separated values, to import into Excel.

[Tsvetomir]

Hi Robert,

I apologize for the misinformation. 

Indeed, the aggregates for the series are not readily available via the options of the series. This is due to the fact that they are calculated dynamically during the render event of the widget and are directly drawn on the surface.

However, you could access the aggregate operator itself and the data for the series via the options. The actual aggregated values have to be explicitly calculated.

var chart = $("#chart").getKendoChart();
var series = chart.options.series[0];

// calculate aggregate based on the data and aggregate from the series.

I hope you find this helpful.

 

Regards,
Tsvetomir
Progress Telerik