Flexmonster - Define types for JSON data
HTML
<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>
JavaScript
flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", {
licenseKey: "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I",
configuratorActive: false,
classicView: true,
rows: [{uniqueName: "customer code"}, {uniqueName: "[Measures]"}],
measures: [{uniqueName: "revenue (net)"}],
data: getData()
}, true);
function getData() {
return [{
"legal entity": { type: "string" }, "function": { type: "string" }, "customer code": { type: "string" }, "marketing": { type: "number" }, "pretax earnings": { type: "number" }, "r&d": { type: "number" }, "revenue (net)": { type: "number" } }, {
"legal entity": "30FR",
"function": "0",
"customer code": 1002,
"marketing": 4106097.6210000003,
"pretax earnings": 123323.44434,
"r&d": 0,
"revenue (net)": 40332397.6522529
}, {
"legal entity": "32NL",
"function": "Manufacturing",
"customer code": 1003,
"marketing": 0,
"pretax earnings": 414671.79097289604,
"r&d": 5465655.5889608,
"revenue (net)": 23321564.517543554
}, {
"legal entity": "34LU",
"function": "LRD",
"customer code": 1004,
"marketing": 5505809.096000002,
"pretax earnings": 4015966.5592195,
"r&d": 0,
"revenue (net)": 53336791.80493299
}];
}