JSFiddle - React, Tailwind, and code Playground

Calculated measures

by Flexmonster Pivot Table

HTML

<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: {
        "Date": {type: "date string"}
      }
    },
    slice: {
      pages: [{
        uniqueName: "Category"
      }],
      rows: [{
        uniqueName: "Color"
      }],
      columns: [{
        uniqueName: "[Measures]"
      }],
      measures: [{
        uniqueName: "Date"
      }, {
        uniqueName: "Formula #1",
        caption: "Formula #1",
        formula: "if(isNaN(max('Date')), 1, 0"
      }],
      
    },
    options: {
      grid: {
        type: "flat"
      }
    }
  }
});

function getData() {
  return [
    {
      "Date": "2021-04-25",
    },
    {
      "Date": null
    }
  ]
}