Flexmonster - Load CSV file
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
<script src="https://s3.amazonaws.com/flexmonster/2.3/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
var jsondata = [
{
"Retail Week": "Retail Week 31",
"Plan/Previous": "Plan",
"Sales Unit": 5,
"Promotion Unit": 3
},
{
"Retail Week": "Retail Week 31",
"Plan/Previous": "Previous",
"Sales Unit": 3,
"Promotion Unit": 1
},
{
"Retail Week": "Retail Week 32",
"Plan/Previous": "Plan",
"Sales Unit": 3,
"Promotion Unit": 2
},
{
"Retail Week": "Retail Week 32",
"Plan/Previous": "Previous",
"Sales Unit": 5,
"Promotion Unit": 2
},
{
"Retail Week": "Retail Week 33",
"Plan/Previous": "Plan",
"Sales Unit": 2,
"Promotion Unit": 2
},
{
"Retail Week": "Retail Week 33",
"Plan/Previous": "Previous",
"Sales Unit": 6,
"Promotion Unit": 1
},
];
var pivot = $("#pivot-container").flexmonster({
report: {
dataSource: {
data: jsondata
},
slice: {
rows: [{
uniqueName: "[Measures]"
}, {
uniqueName: "Plan/Previous"
}],
columns: [{
uniqueName: "Retail Week"
}],
measures: [{
uniqueName: "Sales Unit"
}, {
uniqueName: "Promotion Unit"
}],
},
options: {
grid: {
showGrandTotals: "off"
}
}
},
width: "100%",
height: 400,
componentFolder: "https://s3.amazonaws.com/flexmonster/2.3/"
});