JSON data source

Data source

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<div id="pivot-container"></div>

JavaScript

var jsonData = [
	{
  	number: { type: "number" },
    date: { type: "datetime"},
    name: { type: "string" },
  },
	{ number: 1, date: new Date('2017-01-01'), name: 'a' },
  { number: 2, date: new Date('2017-01-02'), name: 'b' },
  { number: 3, date: new Date('2017-01-03'), name: 'c' },
  { number: 4, date: new Date('2017-01-04'), name: 'b' },
  { number: 5, date: new Date('2017-01-05'), name: 'c' },
  { number: 6, date: new Date('2017-01-06'), name: 'c' },
];

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
		toolbar: true,
		report: {
			dataSource: {
				data: jsonData
			},
			slice: {
				rows: [
          { uniqueName: "number" },
				],
				columns: [
        	{ uniqueName: "name" },
        	{ uniqueName: "[Measures]" },
				],
				measures: [
          {
            uniqueName: "date", 
            aggregation: "max",
          },
					{
            uniqueName: "number", 
            aggregation: "max",
          }
				],
			},
		},
	});