Totals on clustered column stacks
This demo shows how we can dynamically calculate totals of columns in a multi-stack scenario in a bullet function.
/** * --------------------------------------- * This demo was created using amCharts 5. * * For more information visit: * https://www.amcharts.com/ * * Documentation is available at: * https://www.amcharts.com/docs/v5/ * --------------------------------------- */
// Create root element// https://www.amcharts.com/docs/v5/getting-started/#Root_elementvar root = am5.Root.new("chartdiv");
// Set themes// https://www.amcharts.com/docs/v5/concepts/themes/root.setThemes([am5themes_Animated.new(root)]);
// Create chart// https://www.amcharts.com/docs/v5/charts/xy-chart/var chart = root.container.children.push( am5xy.XYChart.new(root, { panX: false, panY: false, wheelX: "panX", wheelY: "zoomX", layout: root.verticalLayout }));
// Add legend// https://www.amcharts.com/docs/v5/charts/xy-chart/legend-xy-series/var legend = chart.children.push( am5.Legend.new(root, { centerX: am5.p50, x: am5.p50 }));
var data = [ { year: "2021", europe: 2.5, namerica: 2.5, asia: 2.1, lamerica: 1, meast: 0.8, africa: 0.4 }, { year: "2022", europe: 2.6, namerica: 2.7, asia: 2.2, lamerica: 0.5, meast: 0.4, africa: 0.3 }, { year: "2023", europe: 2.8, namerica: 2.9, asia: 2.4, lamerica: 0.3, meast: 0.9, africa: 0.5 }];
// Create axes// https://www.amcharts.com/docs/v5/charts/xy-chart/axes/var xAxis = chart.xAxes.push( am5xy.CategoryAxis.new(root, { categoryField: "year", renderer: am5xy.AxisRendererX.new(root, { cellStartLocation: 0.1, cellEndLocation: 0.9 }),
tooltip: am5.Tooltip.new(root, {}) }));
xAxis.data.setAll(data);
var yAxis = chart.yAxes.push( am5xy.ValueAxis.new(root, { min: 0, renderer: am5xy.AxisRendererY.new(root, {}), calculateTotals: true }));
// Add series// https://www.amcharts.com/docs/v5/charts/xy-chart/series/function makeSeries(name, fieldName, stacked, total) { var series = chart.series.push( am5xy.ColumnSeries.new(root, { stacked: stacked, name: name, xAxis: xAxis, yAxis: yAxis, valueYField: fieldName, categoryXField: "year" }) );
series.columns.template.setAll({ tooltipText: "{name}, {categoryX}:{valueY}", width: am5.percent(90), tooltipY: am5.percent(10) });
if (total) { series.bullets.push(function (target, series, dataItem) { var index = chart.series.indexOf(series); var dataItemIndex = series.dataItems.indexOf(dataItem); var sum = 0; chart.series.eachReverse(function (series, seriesIndex) { if (seriesIndex <= index) { var seriesDataItem = series.dataItems[dataItemIndex]; sum += seriesDataItem.get("valueY"); if (!series.get("stacked")) { index = -1; } } }); return am5.Bullet.new(root, { locationY: 1, sprite: am5.Label.new(root, { text: root.numberFormatter.format(sum), fill: am5.color(0x000000), centerY: am5.p100, centerX: am5.p50, populateText: true }) }); }); }
series.data.setAll(data);
// Make stuff animate on load // https://www.amcharts.com/docs/v5/concepts/animations/ series.appear();
//console.log(series.dataItems[1])
legend.data.push(series);}
makeSeries("Europe", "europe", false);makeSeries("North America", "namerica", true, true);makeSeries("Asia", "asia", false);makeSeries("Latin America", "lamerica", true);makeSeries("Middle East", "meast", true);makeSeries("Africa", "africa", true, true);
// Make stuff animate on load// https://www.amcharts.com/docs/v5/concepts/animations/chart.appear(1000, 100);<div id="chartdiv"></div>body { font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol";}
#chartdiv { width: 100%; height: 95vh;}{ "type": "XYChart", "settings": { "panX": false, "panY": false, "wheelX": "panX", "wheelY": "zoomX", "layout": { "type": "VerticalLayout" } }, "properties": { "series": [ "#series-0", "#series-1", "#series-2", "#series-3", "#series-4", "#series-5" ], "xAxes": [ "#axis-0" ], "yAxes": [ "#axis-1" ] }, "children": [ { "type": "Legend", "settings": { "centerX": { "type": "Percent", "value": 50 }, "x": { "type": "Percent", "value": 50 } }, "properties": { "data": [ "#series-0", "#series-1", "#series-2", "#series-3", "#series-4", "#series-5" ] } } ], "refs": [ { "data-0": [ { "year": "2021", "europe": 2.5, "namerica": 2.5, "asia": 2.1, "lamerica": 1, "meast": 0.8, "africa": 0.4 }, { "year": "2022", "europe": 2.6, "namerica": 2.7, "asia": 2.2, "lamerica": 0.5, "meast": 0.4, "africa": 0.3 }, { "year": "2023", "europe": 2.8, "namerica": 2.9, "asia": 2.4, "lamerica": 0.3, "meast": 0.9, "africa": 0.5 } ] }, { "axis-0": { "type": "CategoryAxis", "settings": { "categoryField": "year", "renderer": { "type": "AxisRendererX", "settings": { "cellStartLocation": 0.1, "cellEndLocation": 0.9 } }, "tooltip": { "type": "Tooltip" } }, "properties": { "data": "#data-0" } } }, { "axis-1": { "type": "ValueAxis", "settings": { "min": 0, "renderer": { "type": "AxisRendererY" }, "calculateTotals": true } } }, { "series-0": { "type": "ColumnSeries", "settings": { "stacked": false, "name": "Europe", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "europe", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } } } } }, { "series-1": { "type": "ColumnSeries", "settings": { "stacked": true, "name": "North America", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "namerica", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } }, "bullets": [ { "type": "Bullet", "settings": { "locationY": 1, "sprite": { "type": "Label", "settings": { "text": "5", "fill": { "type": "Color", "value": "#000000" }, "centerY": { "type": "Percent", "value": 100 }, "centerX": { "type": "Percent", "value": 50 }, "populateText": true } } } } ] } } }, { "series-2": { "type": "ColumnSeries", "settings": { "stacked": false, "name": "Asia", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "asia", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } } } } }, { "series-3": { "type": "ColumnSeries", "settings": { "stacked": true, "name": "Latin America", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "lamerica", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } } } } }, { "series-4": { "type": "ColumnSeries", "settings": { "stacked": true, "name": "Middle East", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "meast", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } } } } }, { "series-5": { "type": "ColumnSeries", "settings": { "stacked": true, "name": "Africa", "xAxis": "#axis-0", "yAxis": "#axis-1", "valueYField": "africa", "categoryXField": "year" }, "properties": { "data": "#data-0", "columns": { "properties": { "template": { "settings": { "tooltipText": "{name}, {categoryX}:{valueY}", "width": { "type": "Percent", "value": 90 }, "tooltipY": { "type": "Percent", "value": 10 } } } } }, "bullets": [ { "type": "Bullet", "settings": { "locationY": 1, "sprite": { "type": "Label", "settings": { "text": "4.3", "fill": { "type": "Color", "value": "#000000" }, "centerY": { "type": "Percent", "value": 100 }, "centerX": { "type": "Percent", "value": 50 }, "populateText": true } } } } ] } } } ]}totals-on-clustered-column-stacksFor non-clustered column stacks, there’s an easier way. Refer to “Totals on column stacks” tutorial.