Populate pie chart from a Radgrid column

[Kunal]

Hi All, i'm working on producing a dynamic pie chart that's linked to a Radgrid column and updates as the grid is being filtered  . 

 

I have a Radgrid with the following columns; 

application ids'

Application Status (only 3 status's "accepted/declined/in-progress")

Received date from

Revived date to 

BatchID

 

What i'm trying to achieve;

1) Piechart that's based on the application status column 

2) The Pie chart to recalculate when the applications are being filtered by Received date or batchID

 

Any advise or solutions will be much appreciated.

[Marin Bratanov]

Hi Kunal,

Here is a similar example: https://demos.telerik.com/aspnet-ajax/htmlchart/examples/applicationscenarios/htmlchartingridcolumn/defaultcs.aspx?product=htmlchart.

Regards,

Marin Bratanov
Progress Telerik

[Kunal]

Hi Marin, 

My previous explanation wasn't clear enough; 

 

Example Radgrid data

AppID | AppStatus | FromDate | ToDate 

1 | In-Progress | 01012017 | 02022017

2 | Accepted | 01012017 | 02022017

3 | Declined | 03012017 | 04022017

4 | Declined | 03012017 | 04022017

5 | Accepted | 03012017 | 04022017

 

I need a piechart to be displayed outside the radgrid. it also needs to find all the unique values in the AppStatus column and show the total occourance of each Status.

 

With the example data i need the piechart to show 

inprogress =1

declined = 2

accepted = 2

 

the next part would be to have the pie chart update every time i filter the data.

for example if i filter between 03012017 - 04022017  the pie chart should show;

 

in-progress = 0

declined = 2

accepted = 1

 

[Marin Bratanov]

Hi,
I have answered your support ticket with this question and I am pasting the same guidance here as well, in case someone has such a question in the future.

---

The chart needs a data source with the appropriate data, so as soon as you provide that, it can display the data. This means that you would need to aggregate the original data into the desired format. You may find useful the following article on data binding a chart and the data format it needs: https://docs.telerik.com/devtools/aspnet-ajax/controls/htmlchart/data-binding/overview.

To get what the user filters in the grid, you can use the ItemCommand of the grid: https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Filtering/operate-with-the-filterexpression-manually. This will allow you to filter the data source you have in order to then aggregate it for the chart.

Regards,
Marin Bratanov
Progress Telerik