Flexmonster Demo - empty values in JSON
HTML
<script src="https://s3.amazonaws.com/flexmonster/2.2/flexmonster.js"></script>
<div id="pivot-content"></div>
JavaScript
var jsondata = [{
"Color": "green",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 1724,
"Quantity": 212
}, {
"Color": "red",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": "",
"Quantity": 1319
}];
function jsPivotCreationCompleteHandler() {
var report = {
configuratorActive: false,
data: jsondata,
rows: [{uniqueName: "Color"}],
columns: [{uniqueName: "[Measures]"}],
measures: [{uniqueName: "Price", format: "currency"}, {uniqueName: "Quantity"}],
formats: [{name: ""/* for all measures*/, decimalSeparator: ",", thousandsSeparator: " ", currencySymbol: "", decimalPlaces: 0},
{name: "currency"/* for measures with format='currency'*/, nullValue: "blank", decimalSeparator: ",", thousandsSeparator: " ", currencySymbol: "$", decimalPlaces: 2}]
};
flexmonster.setReport(report);
console.log(flexmonster.getReport());
}
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",
jsPivotCreationCompleteHandler: "jsPivotCreationCompleteHandler"
}, true);