JSFiddle - React, Tailwind, and code Playground
by Flexmonster Pivot Table
HTML
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="setData(getData1())"> setData1</button>
<button onclick="setData(getData2())"> setData2</button>
<div id="pivot-container"></div>
JavaScript
var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
toolbar: true,
report: {
dataSource: {
data: getData1()
},
slice: {
measures: [{
uniqueName: "Price",
aggregation: "sum"
}],
rows: [{
filter: {
members: ["color.[red]"]
},
uniqueName: "Color"
}],
columns: [{
filter: {
members: ["city.[los angeles]"]
},
uniqueName: "City"
}]
}
}
});
function setData(data) {
let prevFilters = getFilters();
let report = pivot.getReport();
report.dataSource.data = data;
pivot.setReport(report);
pivot.on('reportcomplete', function() {
pivot.off("reportcomplete");
let currFilters = getFilters();
checkFilters(prevFilters, currFilters);
});
}
function checkFilters(prevFilters, currFilters) {
let missingFilters = [];
for (let filter of prevFilters) {
if (!currFilters.includes(filter)) {
missingFilters.push(filter);
}
}
if (missingFilters.length > 0) {
let extractedValues = missingFilters.map(filter => {
let key = Object.keys(filter)[0];
let value = filter[key][0];
let match = value.match(/(.+?)\./);
return match ? match[1] : null;
});
handleEmptyData(extractedValues.join(", "))
}
}
function getFilters() {
let fields = pivot.getAllHierarchies();
let filters = [];
for (let f of fields)
if (pivot.getFilter(f.uniqueName))
filters.push(pivot.getFilter(f.uniqueName));
return filters;
}
function handleEmptyData(filters) {
pivot.alert({
title: "No data found for filters " + filters,
message: "No data is available for the selected filters. Showing all data.",
type: "info",
blocking: false
});
}
function getData1() {
return [{
"Color": "green",
"Country": "Canada",
"State": "Ontario",
"City": "Toronto",
"Price": 174,
...