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>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/lodash.min.js"></script>

<div id="pivotContainer"></div>

JavaScript

let endpointUrl = "https://olap.flexmonster.com:9500/";
let index = "fm-product-sales";

let pivot1 = new Flexmonster({
  container: "pivotContainer",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    "dataSource": {
      "type": "api",
      "url": pivotEndpoint,
      "index": index
    }
  }
});

function pivotEndpoint(requestStringified, done) {
  let request = JSON.parse(requestStringified);

  if (request.type == "fields") {
    done({
      "fields": [{
        "uniqueName": "uniqueName",
        "type": "string",
        "caption": "UniqueName",
        "filters": {
          "members": true,
          "query": false,
          "valueQuery": false
        }
      }],
      "aggregations": {
        "any": [
          "count",
          "distinctcount"
        ],
        "date": [
          "count",
          "distinctcount",
          "min",
          "max"
        ],
        "number": [
          "sum",
          "average",
          "count",
          "distinctcount",
          "min",
          "max"
        ]
      },
      "filters": {
        "date": {
          "members": true,
          "query": [
            "equal",
            "not_equal",
            "after",
            "after_equal",
            "before",
            "before_equal",
            "between",
            "not_between",
            "last",
            "current",
            "next"
          ],
          "valueQuery": [
            "equal",
            "not_equal",
            "greater",
            "greater_equal",
            "less",
            "less_equal",
            "between",
            "not_between"
          ]
        },
        "number": {
          "members": true,
          "query": [
            "equal",
            "not_equal",
            "greater",
            "greater_equal",
            "less",
            "less_equal",
            "between",
            "not_between"
          ],
          "valueQuery": [
            "equal",
...