nested json to plain

also mentioning array as a value, and mapping

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>

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

JavaScript

var jsonData = [
/* 	before:
	{
	  "$date": "2020-06-12T15:54:51.556Z",
	    "color": "red",
	    "role": ["lead", "junior"]
	} */
	{
		"$date": "2020-06-12T15:54:51.556Z",
    "color": "red",
    "role": "lead"
	},
  {
		"$date": "2020-06-12T15:54:51.556Z",
    "color": "red",
    "role": "junior"
	},
];



var pivot = new Flexmonster({
  container: "pivotContainer",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    dataSource: {
      data: jsonData,
    },
    mapping: {
    	"$date": {
      	type: "date string"
      },
      "color": {},
      "role": {}
    }
  }
});