pivot() demo
https://github.com/nicolaskruchten/pivottable
by Nicolas Kruchten
HTML
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/pivottable/2.13.0/pivot.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/pivottable/2.13.0/pivot.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pivottable/2.6.0/tips_data.min.js"></script>
<div id="output"></div>
CSS
body {
font-family: Verdana;
}
JavaScript
var utils = $.pivotUtilities;
var heatmap = utils.renderers["Heatmap"];
var sumOverSum = utils.aggregators["Sum over Sum"];
$("#output").pivotUI(
[
{"key": "2011/09", "val": 7523},
{"key": "2012/09", "val": 15554},
{"key": "2013/09", "val": 11476},
{"key": "2014/09", "val": 14018},
{"key": "2015/09", "val": 14654},
{"key": "2016/09", "val": 13260},
{"key": "2017/09", "val": 22777},
{"key": "2018/09", "val": 60}
], {
rows: ["key"],
vals: ["val"],
aggregatorName: "Average"
});