JSFiddle - React, Tailwind, and code Playground
by Ian Sadovy
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 data = [{
"time": {
"type": "date string"
},
"hours": {
"type": "number"
},
"price": {
"type": "number"
},
"value": {
"type": "number"
}
}, {
"time": "2016-01-01",
"hours": 744,
"price": 20
}, {
"time": "2016-02-01",
"hours": 672,
"price": 30
}, {
"time": "2016-03-01",
"hours": 743,
"price": 20
}, {
"time": "2016-04-01",
"hours": 720,
"price": 30
}, {
"time": "2016-05-01",
"hours": 744,
"price": 20
}, {
"time": "2016-06-01",
"hours": 720,
"price": 30
}, {
"time": "2016-07-01",
"hours": 744,
"price": 20
}, {
"time": "2016-08-01",
"hours": 744,
"price": 30
}, {
"time": "2016-09-01",
"hours": 720,
"price": 20
}, {
"time": "2016-10-01",
"hours": 745,
"price": 30
}, {
"time": "2016-11-01",
"hours": 720,
"price": 20
}, {
"time": "2016-12-01",
"hours": 744,
"price": 30
}];
var pivot = $("#pivot-container").flexmonster({
componentFolder: "https://s3.amazonaws.com/flexmonster/2.3/",
width: "100%",
height: 430,
toolbar: true,
report: {
dataSource: {
data: data
},
slice: {
columns: [{
uniqueName: "[Measures]"
}],
rows: [{
uniqueName: "time"
}],
measures: [{
uniqueName: "hours"
}, {
uniqueName: "price"
}, {
uniqueName: "sales",
formula: 'sum("hours") * sum("price")',
individual: true,
caption: "sales",
active: true
}, {
uniqueName: "price wavg",
formula: '"sales" / sum("hours")',
individual: false,
caption: "price wavg",
active: true
}],
},
options: {
configuratorActive: false
},
formats: [{
name: "",
decimalPlaces: 2
}]
}
});