For the company I am working for I am looking for a simple and good performing solution for a problem.
We want to display a grid with filtering next to a chart which displays one or more series based on the data in the grid.
When the filter is altered the data in the grid, but also the data in the chart should be updated.
Is it possible to simply connect your RadGrid to RadHTMLChart to get this behaviour?
And how/can the data be shared between those two components and if so are there limitations?
I did read that your RadGrid support EntityDataSource and your own ClientDataSource, but I did not see anything about this in the RadHTMLChart component documentation.
For example if I want to fill the grid with data about cars with these columns: "Brand", "Year" and "Price".
And next to the grid I wanted to display two charts:
A pie chart with the number of cars per brand
A bar graph with the cumulative prices per year per brand.
Could this be achieved quite easily by setting the data source of the grid to the charts and setting up the series/axis correctly?
Or is it required to create queries specific for the chart?
For example for the pie chart of the example should "Brand" and "Number of cars" be selected?
Hopefully you can answer these questions for me (and have I posted this in the correct forum)
With kind regards,
Sjoerd van Loon
Senior Software Engineer