Your search did not match any results.
Charts

Discrete Aggregation

The aggregation algorithm depends on the aggregateByCategory property. In this demo, this property is set to true and applies the "sum" aggregation method for the groups specified in the dataSource.

If aggregateByCategory is false, the specified aggregation method is not applied.

U.S. Energy Information Administration (Oct 2019)
Backend API
Copy to CodePen
Apply
Reset
$(() => { $('#chart').dxChart({ dataSource, title: { text: 'Production of Crude Oil', subtitle: '(in Barrels)', }, commonSeriesSettings: { aggregation: { enabled: true, method: 'sum', }, argumentField: 'state', valueField: 'value', type: 'bar', }, seriesTemplate: { nameField: 'year', }, argumentAxis: { aggregateByCategory: true, }, }); });
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/21.2.3/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/21.2.3/css/dx.light.css" /> <script src="https://cdn3.devexpress.com/jslib/21.2.3/js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type="text/css" href="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="chart"></div> </div> </body> </html>
#chart { height: 440px; }
const dataSource = [ { state: 'Alaska', month: 'Jan', year: '2016', value: 15985000, }, { state: 'Alaska', month: 'Feb', year: '2016', value: 14713000, }, { state: 'Alaska', month: 'Mar', year: '2016', value: 15842000, }, { state: 'Alaska', month: 'Apr', year: '2016', value: 14665000, }, { state: 'Alaska', month: 'May', year: '2016', value: 15658000, }, { state: 'Alaska', month: 'Jun', year: '2016', value: 14103000, }, { state: 'Alaska', month: 'Jul', year: '2016', value: 13584000, }, { state: 'Alaska', month: 'Aug', year: '2016', value: 14265000, }, { state: 'Alaska', month: 'Sep', year: '2016', value: 13598000, }, { state: 'Alaska', month: 'Oct', year: '2016', value: 15383000, }, { state: 'Alaska', month: 'Nov', year: '2016', value: 15433000, }, { state: 'Alaska', month: 'Dec', year: '2016', value: 16148000, }, { state: 'Alaska', month: 'Jan', year: '2017', value: 16055000, }, { state: 'Alaska', month: 'Feb', year: '2017', value: 14434000, }, { state: 'Alaska', month: 'Mar', year: '2017', value: 16300000, }, { state: 'Alaska', month: 'Apr', year: '2017', value: 15759000, }, { state: 'Alaska', month: 'May', year: '2017', value: 15734000, }, { state: 'Alaska', month: 'Jun', year: '2017', value: 13843000, }, { state: 'Alaska', month: 'Jul', year: '2017', value: 13102000, }, { state: 'Alaska', month: 'Aug', year: '2017', value: 13971000, }, { state: 'Alaska', month: 'Sep', year: '2017', value: 14465000, }, { state: 'Alaska', month: 'Oct', year: '2017', value: 15705000, }, { state: 'Alaska', month: 'Nov', year: '2017', value: 15297000, }, { state: 'Alaska', month: 'Dec', year: '2017', value: 15883000, }, { state: 'Alaska', month: 'Jan', year: '2018', value: 15739000, }, { state: 'Alaska', month: 'Feb', year: '2018', value: 14367000, }, { state: 'Alaska', month: 'Mar', year: '2018', value: 15878000, }, { state: 'Alaska', month: 'Apr', year: '2018', value: 14922000, }, { state: 'Alaska', month: 'May', year: '2018', value: 15367000, }, { state: 'Alaska', month: 'Jun', year: '2018', value: 13521000, }, { state: 'Alaska', month: 'Jul', year: '2018', value: 12237000, }, { state: 'Alaska', month: 'Aug', year: '2018', value: 13259000, }, { state: 'Alaska', month: 'Sep', year: '2018', value: 14143000, }, { state: 'Alaska', month: 'Oct', year: '2018', value: 15083000, }, { state: 'Alaska', month: 'Nov', year: '2018', value: 14919000, }, { state: 'Alaska', month: 'Dec', year: '2018', value: 15366000, }, { state: 'Colorado', month: 'Jan', year: '2016', value: 10326000, }, { state: 'Colorado', month: 'Feb', year: '2016', value: 9484000, }, { state: 'Colorado', month: 'Mar', year: '2016', value: 9906000, }, { state: 'Colorado', month: 'Apr', year: '2016', value: 9505000, }, { state: 'Colorado', month: 'May', year: '2016', value: 9667000, }, { state: 'Colorado', month: 'Jun', year: '2016', value: 9285000, }, { state: 'Colorado', month: 'Jul', year: '2016', value: 9965000, }, { state: 'Colorado', month: 'Aug', year: '2016', value: 10042000, }, { state: 'Colorado', month: 'Sep', year: '2016', value: 9742000, }, { state: 'Colorado', month: 'Oct', year: '2016', value: 11183000, }, { state: 'Colorado', month: 'Nov', year: '2016', value: 9595000, }, { state: 'Colorado', month: 'Dec', year: '2016', value: 9417000, }, { state: 'Colorado', month: 'Jan', year: '2017', value: 9297000, }, { state: 'Colorado', month: 'Feb', year: '2017', value: 8386000, }, { state: 'Colorado', month: 'Mar', year: '2017', value: 9568000, }, { state: 'Colorado', month: 'Apr', year: '2017', value: 9841000, }, { state: 'Colorado', month: 'May', year: '2017', value: 10487000, }, { state: 'Colorado', month: 'Jun', year: '2017', value: 10147000, }, { state: 'Colorado', month: 'Jul', year: '2017', value: 10980000, }, { state: 'Colorado', month: 'Aug', year: '2017', value: 12039000, }, { state: 'Colorado', month: 'Sep', year: '2017', value: 12187000, }, { state: 'Colorado', month: 'Oct', year: '2017', value: 12951000, }, { state: 'Colorado', month: 'Nov', year: '2017', value: 13095000, }, { state: 'Colorado', month: 'Dec', year: '2017', value: 13918000, }, { state: 'Colorado', month: 'Jan', year: '2018', value: 13962000, }, { state: 'Colorado', month: 'Feb', year: '2018', value: 12467000, }, { state: 'Colorado', month: 'Mar', year: '2018', value: 13966000, }, { state: 'Colorado', month: 'Apr', year: '2018', value: 13924000, }, { state: 'Colorado', month: 'May', year: '2018', value: 14215000, }, { state: 'Colorado', month: 'Jun', year: '2018', value: 13119000, }, { state: 'Colorado', month: 'Jul', year: '2018', value: 13986000, }, { state: 'Colorado', month: 'Aug', year: '2018', value: 16075000, }, { state: 'Colorado', month: 'Sep', year: '2018', value: 15951000, }, { state: 'Colorado', month: 'Oct', year: '2018', value: 16890000, }, { state: 'Colorado', month: 'Nov', year: '2018', value: 16487000, }, { state: 'Colorado', month: 'Dec', year: '2018', value: 16775000, }, { state: 'North Dakota', month: 'Jan', year: '2016', value: 34548000, }, { state: 'North Dakota', month: 'Feb', year: '2016', value: 32252000, }, { state: 'North Dakota', month: 'Mar', year: '2016', value: 34222000, }, { state: 'North Dakota', month: 'Apr', year: '2016', value: 31055000, }, { state: 'North Dakota', month: 'May', year: '2016', value: 32246000, }, { state: 'North Dakota', month: 'Jun', year: '2016', value: 30595000, }, { state: 'North Dakota', month: 'Jul', year: '2016', value: 31724000, }, { state: 'North Dakota', month: 'Aug', year: '2016', value: 30263000, }, { state: 'North Dakota', month: 'Sep', year: '2016', value: 28967000, }, { state: 'North Dakota', month: 'Oct', year: '2016', value: 32144000, }, { state: 'North Dakota', month: 'Nov', year: '2016', value: 30798000, }, { state: 'North Dakota', month: 'Dec', year: '2016', value: 28995000, }, { state: 'North Dakota', month: 'Jan', year: '2017', value: 30264000, }, { state: 'North Dakota', month: 'Feb', year: '2017', value: 28714000, }, { state: 'North Dakota', month: 'Mar', year: '2017', value: 31509000, }, { state: 'North Dakota', month: 'Apr', year: '2017', value: 31208000, }, { state: 'North Dakota', month: 'May', year: '2017', value: 31840000, }, { state: 'North Dakota', month: 'Jun', year: '2017', value: 30693000, }, { state: 'North Dakota', month: 'Jul', year: '2017', value: 32255000, }, { state: 'North Dakota', month: 'Aug', year: '2017', value: 33437000, }, { state: 'North Dakota', month: 'Sep', year: '2017', value: 32883000, }, { state: 'North Dakota', month: 'Oct', year: '2017', value: 36309000, }, { state: 'North Dakota', month: 'Nov', year: '2017', value: 35482000, }, { state: 'North Dakota', month: 'Dec', year: '2017', value: 36085000, }, { state: 'North Dakota', month: 'Jan', year: '2018', value: 36057000, }, { state: 'North Dakota', month: 'Feb', year: '2018', value: 32501000, }, { state: 'North Dakota', month: 'Mar', year: '2018', value: 35538000, }, { state: 'North Dakota', month: 'Apr', year: '2018', value: 36290000, }, { state: 'North Dakota', month: 'May', year: '2018', value: 38137000, }, { state: 'North Dakota', month: 'Jun', year: '2018', value: 36479000, }, { state: 'North Dakota', month: 'Jul', year: '2018', value: 39005000, }, { state: 'North Dakota', month: 'Aug', year: '2018', value: 39648000, }, { state: 'North Dakota', month: 'Sep', year: '2018', value: 40274000, }, { state: 'North Dakota', month: 'Oct', year: '2018', value: 42674000, }, { state: 'North Dakota', month: 'Nov', year: '2018', value: 41442000, }, { state: 'North Dakota', month: 'Dec', year: '2018', value: 43485000, }, { state: 'New Mexico', month: 'Jan', year: '2016', value: 11737000, }, { state: 'New Mexico', month: 'Feb', year: '2016', value: 11551000, }, { state: 'New Mexico', month: 'Mar', year: '2016', value: 12591000, }, { state: 'New Mexico', month: 'Apr', year: '2016', value: 12144000, }, { state: 'New Mexico', month: 'May', year: '2016', value: 12182000, }, { state: 'New Mexico', month: 'Jun', year: '2016', value: 11679000, }, { state: 'New Mexico', month: 'Jul', year: '2016', value: 12146000, }, { state: 'New Mexico', month: 'Aug', year: '2016', value: 12167000, }, { state: 'New Mexico', month: 'Sep', year: '2016', value: 12019000, }, { state: 'New Mexico', month: 'Oct', year: '2016', value: 12655000, }, { state: 'New Mexico', month: 'Nov', year: '2016', value: 12485000, }, { state: 'New Mexico', month: 'Dec', year: '2016', value: 13036000, }, { state: 'New Mexico', month: 'Jan', year: '2017', value: 12979000, }, { state: 'New Mexico', month: 'Feb', year: '2017', value: 12391000, }, { state: 'New Mexico', month: 'Mar', year: '2017', value: 13700000, }, { state: 'New Mexico', month: 'Apr', year: '2017', value: 13423000, }, { state: 'New Mexico', month: 'May', year: '2017', value: 14369000, }, { state: 'New Mexico', month: 'Jun', year: '2017', value: 13318000, }, { state: 'New Mexico', month: 'Jul', year: '2017', value: 13859000, }, { state: 'New Mexico', month: 'Aug', year: '2017', value: 14257000, }, { state: 'New Mexico', month: 'Sep', year: '2017', value: 15043000, }, { state: 'New Mexico', month: 'Oct', year: '2017', value: 16202000, }, { state: 'New Mexico', month: 'Nov', year: '2017', value: 15853000, }, { state: 'New Mexico', month: 'Dec', year: '2017', value: 17204000, }, { state: 'New Mexico', month: 'Jan', year: '2018', value: 16691000, }, { state: 'New Mexico', month: 'Feb', year: '2018', value: 16345000, }, { state: 'New Mexico', month: 'Mar', year: '2018', value: 19171000, }, { state: 'New Mexico', month: 'Apr', year: '2018', value: 19320000, }, { state: 'New Mexico', month: 'May', year: '2018', value: 20002000, }, { state: 'New Mexico', month: 'Jun', year: '2018', value: 19471000, }, { state: 'New Mexico', month: 'Jul', year: '2018', value: 20354000, }, { state: 'New Mexico', month: 'Aug', year: '2018', value: 22052000, }, { state: 'New Mexico', month: 'Sep', year: '2018', value: 22029000, }, { state: 'New Mexico', month: 'Oct', year: '2018', value: 24024000, }, { state: 'New Mexico', month: 'Nov', year: '2018', value: 23796000, }, { state: 'New Mexico', month: 'Dec', year: '2018', value: 25704000, }, { state: 'Oklahoma', month: 'Jan', year: '2016', value: 14137000, }, { state: 'Oklahoma', month: 'Feb', year: '2016', value: 11959000, }, { state: 'Oklahoma', month: 'Mar', year: '2016', value: 13406000, }, { state: 'Oklahoma', month: 'Apr', year: '2016', value: 12533000, }, { state: 'Oklahoma', month: 'May', year: '2016', value: 13236000, }, { state: 'Oklahoma', month: 'Jun', year: '2016', value: 12455000, }, { state: 'Oklahoma', month: 'Jul', year: '2016', value: 12442000, }, { state: 'Oklahoma', month: 'Aug', year: '2016', value: 12910000, }, { state: 'Oklahoma', month: 'Sep', year: '2016', value: 12323000, }, { state: 'Oklahoma', month: 'Oct', year: '2016', value: 13088000, }, { state: 'Oklahoma', month: 'Nov', year: '2016', value: 12778000, }, { state: 'Oklahoma', month: 'Dec', year: '2016', value: 12809000, }, { state: 'Oklahoma', month: 'Jan', year: '2017', value: 12555000, }, { state: 'Oklahoma', month: 'Feb', year: '2017', value: 11806000, }, { state: 'Oklahoma', month: 'Mar', year: '2017', value: 13570000, }, { state: 'Oklahoma', month: 'Apr', year: '2017', value: 12822000, }, { state: 'Oklahoma', month: 'May', year: '2017', value: 13296000, }, { state: 'Oklahoma', month: 'Jun', year: '2017', value: 13485000, }, { state: 'Oklahoma', month: 'Jul', year: '2017', value: 13696000, }, { state: 'Oklahoma', month: 'Aug', year: '2017', value: 14104000, }, { state: 'Oklahoma', month: 'Sep', year: '2017', value: 13749000, }, { state: 'Oklahoma', month: 'Oct', year: '2017', value: 14736000, }, { state: 'Oklahoma', month: 'Nov', year: '2017', value: 14872000, }, { state: 'Oklahoma', month: 'Dec', year: '2017', value: 15215000, }, { state: 'Oklahoma', month: 'Jan', year: '2018', value: 16434000, }, { state: 'Oklahoma', month: 'Feb', year: '2018', value: 14768000, }, { state: 'Oklahoma', month: 'Mar', year: '2018', value: 16820000, }, { state: 'Oklahoma', month: 'Apr', year: '2018', value: 15941000, }, { state: 'Oklahoma', month: 'May', year: '2018', value: 16330000, }, { state: 'Oklahoma', month: 'Jun', year: '2018', value: 15682000, }, { state: 'Oklahoma', month: 'Jul', year: '2018', value: 16700000, }, { state: 'Oklahoma', month: 'Aug', year: '2018', value: 17431000, }, { state: 'Oklahoma', month: 'Sep', year: '2018', value: 17200000, }, { state: 'Oklahoma', month: 'Oct', year: '2018', value: 17861000, }, { state: 'Oklahoma', month: 'Nov', year: '2018', value: 17406000, }, { state: 'Oklahoma', month: 'Dec', year: '2018', value: 18113000, }, { state: 'Texas', month: 'Jan', year: '2016', value: 103269000, }, { state: 'Texas', month: 'Feb', year: '2016', value: 95491000, }, { state: 'Texas', month: 'Mar', year: '2016', value: 100776000, }, { state: 'Texas', month: 'Apr', year: '2016', value: 96368000, }, { state: 'Texas', month: 'May', year: '2016', value: 97849000, }, { state: 'Texas', month: 'Jun', year: '2016', value: 93931000, }, { state: 'Texas', month: 'Jul', year: '2016', value: 97069000, }, { state: 'Texas', month: 'Aug', year: '2016', value: 97037000, }, { state: 'Texas', month: 'Sep', year: '2016', value: 93462000, }, { state: 'Texas', month: 'Oct', year: '2016', value: 97647000, }, { state: 'Texas', month: 'Nov', year: '2016', value: 94758000, }, { state: 'Texas', month: 'Dec', year: '2016', value: 98003000, }, { state: 'Texas', month: 'Jan', year: '2017', value: 98907000, }, { state: 'Texas', month: 'Feb', year: '2017', value: 92400000, }, { state: 'Texas', month: 'Mar', year: '2017', value: 102564000, }, { state: 'Texas', month: 'Apr', year: '2017', value: 99595000, }, { state: 'Texas', month: 'May', year: '2017', value: 105298000, }, { state: 'Texas', month: 'Jun', year: '2017', value: 102763000, }, { state: 'Texas', month: 'Jul', year: '2017', value: 106940000, }, { state: 'Texas', month: 'Aug', year: '2017', value: 103967000, }, { state: 'Texas', month: 'Sep', year: '2017', value: 106077000, }, { state: 'Texas', month: 'Oct', year: '2017', value: 115887000, }, { state: 'Texas', month: 'Nov', year: '2017', value: 115741000, }, { state: 'Texas', month: 'Dec', year: '2017', value: 121005000, }, { state: 'Texas', month: 'Jan', year: '2018', value: 120488000, }, { state: 'Texas', month: 'Feb', year: '2018', value: 112244000, }, { state: 'Texas', month: 'Mar', year: '2018', value: 129348000, }, { state: 'Texas', month: 'Apr', year: '2018', value: 126677000, }, { state: 'Texas', month: 'May', year: '2018', value: 130717000, }, { state: 'Texas', month: 'Jun', year: '2018', value: 130759000, }, { state: 'Texas', month: 'Jul', year: '2018', value: 135682000, }, { state: 'Texas', month: 'Aug', year: '2018', value: 140226000, }, { state: 'Texas', month: 'Sep', year: '2018', value: 139019000, }, { state: 'Texas', month: 'Oct', year: '2018', value: 146462000, }, { state: 'Texas', month: 'Nov', year: '2018', value: 145691000, }, { state: 'Texas', month: 'Dec', year: '2018', value: 151761000, }, ];