JavaScript
var jsondata = [{
"Date": {type: "date string"},
"Color": {type: "string"},
"M": {type: "month"},
"W": {type: "weekday"},
"country": {type: "string"},
"state": {type: "string"},
"city": {type: "string"},
"Price": {type: "number"},
"Quantity": {type: "number"}
},{
"Date": "05/01/2016",
"Color": "green",
"M": "September",
"W": "Wed",
"country": "Canada",
"state": "Ontario",
"city": "Toronto",
"Price": 174,
"Quantity": 22
}, {
"Date": "04/30/2016",
"Color": "red",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": null,
"Quantity": 19
}, {
"Date": null,
"Color": "red",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": 33,
"Quantity": 1
}, {
"Date": "02/11/2016",
"Color": "",
"M": "March",
"W": "Mon",
"Time": "1000",
"country": "USA",
"state": "California",
"city": "Los Angeles",
"Price": 333,
"Quantity": 10
}];
var report = {
configuratorActive: false,
data: jsondata,
viewType: "grid",
rows: [{uniqueName: "Color", filter: {members: ["Color.[]"], negation: true}}],
columns: [{uniqueName: "Date", filter: {members: ["Date.[Invalid date]"], negation: true}}, {uniqueName: "[Measures]"}],
measures: [{uniqueName: "Price", aggregation: "average", availableAggregations: ["average"], active: true}, {uniqueName: "Quantity", aggregation: "average", availableAggregations: ["average"]}],
formats: [{name: "", nullValue: "Keine Angabe"}]
};
report.licenseKey = "Z53G-1T1WC3-1V1M-0L12-2M0A-1233-1I0Y-2Y2Q-1903-322S-0T2C-1I";
flexmonster.embedPivotComponent("https://s3.amazonaws.com/flexmonster/2.2/", "pivot-content", "100%", "600", report, true);