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: {
"Date2": {
type: "date string",
caption: "Date (date string)"
},
"Date3": {
type: "datetime",
caption: "Date (datetime)"
}
}
},
slice: {
rows: [
{
uniqueName: "Date1.Year"
},
{
uniqueName: "Date1.Month"
},
{
uniqueName: "Date1.Day"
},
{
uniqueName: "Date2"
}
],
columns: [
{
uniqueName: "[Measures]"
}
],
measures: [
{
uniqueName: "Date3",
aggregation: "max"
}
]
},
options: {
grid: {
type: "flat"
}
}
}
});
function getData() {
return [
{
"Date1": "2021-03-04T22:52:00",
"Date2": "2021-03-04T22:52:00",
"Date3": "2021-03-04T22:52:00"
},
{
"Date1": "2020-01-11T23:55:00",
"Date2": "2020-01-11T23:55:00",
"Date3": "2020-01-11T23:55:00"
},
{
"Date1": "2021-03-08T22:45:00",
"Date2": "2021-03-08T22:45:00",
"Date3": "2021-03-08T22:45:00"
}
]
}