Define "date", "date string", and "datetime" types using the mapping

Mapping configuration

by Flexmonster Pivot Table

HTML

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

<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: getData(),
      mapping: {
        "Date1": {
          type: "date",
          caption: "Date"
        },
        "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"
    }
  ]
}