Flexmonster - Pivot Table demo

Demos

by falconeri

HTML

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Flexmonster Bug Test</title>
</head>
<body>
    <div id="flexmonster-container"></div>

    <script src="https://cdn.flexmonster.com/flexmonster.js"></script>
</body>
</html>

CSS

/* Selection highlight*/
#fm-pivot-view .fm-grid-column {
    min-width: 20px !important;
    width: 20px !important;
}

JavaScript

let pivot = new Flexmonster({
    container: "flexmonster-container",
    componentFolder: "https://cdn.flexmonster.com/",
    toolbar: true,
    height: 520,
    report: {
        dataSourceType: "csv",
        dataSource: {
            filename: "https://raw.githubusercontent.com/falconeri/flexmonsterbug/main/generated_data.csv"
        },
        mapping: {
            "price": {"caption": "PRICE", "type": "number"},
            "day": {"caption": "DAY", "type": "date string"},
            "hour": {"caption": "HOUR"},
            "hour_id": {"caption": "HOUR ID", "type": "string"},
            "operation": {"caption": "OPERATION"},
            "operation_id": {"caption": "OPERATION ID", "type": "string"},
            "country": {"caption": "COUNTRY"},
            "country_id": {"caption": "COUNTRY ID", "type": "string"},
            "operator": {"caption": "OPERATOR"},
            "operator_id": {"caption": "OPERATOR ID", "type": "string"},
            "aggregations": {
                "number": [
                    "sum",
                    "average",
                    "median",
                    "min",
                    "max",
                    "percent",
                    "percentofcolumn",
                    "percentofrow",
                    "percentofparentcolumntotal",
                    "percentofparentrowtotal",
                    "differenceofcolumn",
                    "differenceofrow",
                    "%differenceofcolumn",
                    "%differenceofrow",
                    "runningtotalsofcolumn",
                    "runningtotalsofrow"
                ]
            },
        },
        slice: {
            "reportFilters": [
                {
                    "uniqueName": "country",
                    "filter": {
                        "members": ["country.[india]"]
                    }
                }
            ],
            "rows": [
                {"uniqueName": "day"},
               ...