pivot() date sorting
https://github.com/nicolaskruchten/pivottable
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/moment.js/2.19.1/moment.min.js"></script>
<div id="output"></div>
CSS
body {
font-family: Verdana;
}
JavaScript
$("#output").pivot(
[
["date","color"],
["15-12-17", "blue"],
["15-12-17", "red"],
["13-12-17", "blue"],
["16-12-17", "blue"],
["15-11-17", "red"],
["15-12-16", "yellow"],
["14-12-16", "yellow"]
],
{
rows: ["date"],
cols: ["color"],
sorters:{
"date": function(a,b){
return moment(b, "DD-MM-YY").diff(moment(a, "DD-MM-YY"));
}
}
});