JSFiddle - React, Tailwind, and code Playground
by Flexmonster Pivot Table
HTML
<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>
JavaScript
let pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: getData(),
mapping: {
"Date1": {
type: "datetime",
caption: "Date"
},
}
},
slice: {
rows: [{
uniqueName: "Date1",
"filter": {
"query": {
"equal": 1615232700000
},
"include": [
"date1.[1614887520000]"
]
}
}, ],
columns: [{
uniqueName: "[Measures]"
}],
measures: [{
uniqueName: "Price",
aggregation: "max"
}]
},
}
});
function getData() {
return [{
"Date1": "2021-03-04T22:52:00+03:00",
"Price": 10
},
{
"Date1": "2020-01-11T23:55:00+03:00",
"Price": 20
},
{
"Date1": "2021-03-08T22:45:00+03:00",
"Price": 30
}
]
}