Grid data pie in EJ2 JavaScript Chart control

8 May 20236 minutes to read

You can visualize the filtered data that returned by grid in pie chart.

To visualize the data in pie chart, follow the given steps:

Step 1:

Initialize the grid with datasource.

Step 2:

By using the grid’s actionComplete event and getCurrentViewRecords method, you can get the current page records. By setting allowFiltering value as true, you can filter the data. By using the grid’s databound event, you can update the current page filtered records into the chart’s datasource and display the grid filtered data in chart.

var chart = new ej.charts.Chart();
var filtertype = [
    { id: 'Menu', type: 'Menu' },
    { id: 'CheckBox', type: 'CheckBox' },
    { id: 'Excel', type: 'Excel' }
];

var grid = new ej.grids.Grid(
    {
        dataSource: orderData,
        allowPaging: true,
        allowFiltering: true,
        filterSettings: { type: 'Menu' },
        columns: [
            { field: 'OrderID', headerText: 'Order ID', width: 120, textAlign: 'Right' },
            { field: 'CustomerName', headerText: 'Customer Name', width: 150 },
            {
                field: 'OrderDate', headerText: 'Order Date', width: 130,
                format: { type: 'dateTime', format: 'M/d/y hh:mm a' }, textAlign: 'Right'
            },
            { field: 'Freight', width: 120, format: 'C2', textAlign: 'Right' }
        ],
        pageSettings: { pageCount: 5 },
        dataBound: function () {
            chart = new ej.charts.AccumulationChart({
                series: [
                    {
                        dataSource: grid.getCurrentViewRecords(),
                        type: 'Pie',
                        xName: 'CustomerName',
                        yName: 'Freight', dataLabel: { visible: true }
                    }
                ]
            }, '#Chart');
        },
        actionComplete: function (args) {
            if (args.requestType === 'paging') {
                chart.series[0].dataSource = grid.getCurrentViewRecords();
                chart.refresh();
            }
        }
    }, '#Grid');
<!DOCTYPE html>
<html lang="en">

<head>
  <title>EJ2 Animation</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta name="description" content="Typescript UI Controls">
  <meta name="author" content="Syncfusion">
  <link href="https://cdn.syncfusion.com/ej2/material.css" rel="stylesheet">
  <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">


  <script src="https://cdn.syncfusion.com/ej2/29.1.33/dist/ej2.min.js" type="text/javascript"></script>
  <script src="es5-datasource.js" type="text/javascript"></script>
<script src="https://cdn.syncfusion.com/ej2/syncfusion-helper.js" type ="text/javascript"></script>
</head>

<body>

  <div class="container">
    <div id="Grid"></div>
    <div id="Chart"></div>
  </div>


  <script>
    var ele = document.getElementById('container');
    if (ele) {
      ele.style.visibility = "visible";
    }   
  </script>
  <script src="index.js" type="text/javascript"></script>
</body>

</html>