Load data from a DataTable to a Chartview.

[SANDRO]

Hi, good morning.

I am using a Pivotgrid, PivotFieldList and Chartview.

The chartview graphs whatever the Pivotgrid has, but there are times when the Pivotgrid has too many records and the Chartview takes a long time to generate.

As seen in the documentation, a Chartview takes time, because it is recalculating the points to regenerate the graph, after having created it previously.

This has led me to think that if instead of the Chartview graphing the Pivotgrid, it would better graph a DataTable.

My idea is the following:
I already generated a filtered DataTable, the result of the interaction between the Pivotgrid and the PivotFieldList and that DataTable fills the Chartview to generate the graph, I think it would take less time to create the graph, since each time the filtered DataTable would be created.

I was looking at this example that you provide to create a graph from a datatable:
https://www.telerik.com/forums/use-radgridview-as-a-datasource-for-radchartview

But it does not graph as expected, that is, it does not show the graphs the same as when the pivotgrid is filled.

Is it possible to do this, or even if you do, will the graph creation time be the same? Because if so, there is no point in working on this solution.

 

Thank you very much for your attention.

[Dinko | Tech Support Engineer]

Hi SANDRO,

The performance of the chart depends on the number of visualized points. If the DataTable contains fewer points than the incoming data from RadPivotGrid, the performance should improve. In general, the Tips and Tricks to Optimize RadChartView's Performance KB article describes several steps to increase the performance of the control. Also, we have a feature request in our Feedback Portal to expose aggregate data points. 

Regarding the generation of the DataTable, I am not familiar with how the table is generated. If you can isolate your approach in a standalone project I could take a look and try to find what is the difference. Basically, the chart is populated by a PivotGridChartDataProvider object. So the data depends on the settings applied to the provider which I think are not taken into account when manually generating the DataTable. You could check the provider properties.

Regards,
Dinko | Tech Support Engineer
Progress Telerik