Column chart
Integration with Highcharts
by Dongor7
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<script src="https://cdn.flexmonster.com/lib/flexmonster.highcharts.js"></script>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/highcharts-more.js"></script>
<div id="pivot-container"></div>
<br/>
<div id="highcharts-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
licenseFilePath: "https://cdn.flexmonster.com/jsfiddle.charts.key",
toolbar: false,
report: {
dataSource: {
dataSourceType: "json",
data: getData()
},
slice: {
rows: [{
uniqueName: "Country"
}, {
uniqueName: "[Measures]"
}],
columns: [{
uniqueName: "Category"
}],
measures: [{
uniqueName: "Price"
}]
},
options: {
viewType: "grid",
configuratorActive: false
}
},
height: 250,
reportcomplete: function() {
pivot.off("reportcomplete");
createChart();
}
});
function createChart() {
pivot.highcharts.getData({
type: "stacked_column",
prepareDataFunction: function (data) {
console.log(data)
return {
xAxis: {
},
yAxis: {
},
}
}
},
function(chartConfig) {
Highcharts.chart('highcharts-container', chartConfig);
},
function(chartConfig) {
Highcharts.chart('highcharts-container', chartConfig);
}
);
}
function getData() {
return [{
"Country": "Australia",
"Category": "Accessories",
"Price": 445,
"Quantity": 464
}, {
"Country": "Australia",
"Category": "Bikes",
"Price": 665,
"Quantity": 440
}, {
"Country": "France",
"Category": "Clothing",
"Price": 190,
"Quantity": 310
}, {
"Country": "United States",
"Category": "Components",
"Price": 406,
"Quantity": 127
}, {
"Country": "United States",
"Category": "Bikes",
"Price": 85,
"Quantity": 831
}, {
"Country": "United Kingdom",
"Category": "Cars",
"Price": 21,
"Quantity": 455
}, {
"Country": "Canada",
"Category": "Clothing",
"Price": 666,
"Quantity": 685
}, {
"Country": "Germany",
"Category": "Cars",
...