Code Snippet

Just another Code Snippet site

[Javascript] Pivot Table

<head>
	<script type="text/javascript" src="scripts/pivot.min.js"></script>
	<script type="text/javascript" src="scripts/jquery.ui.touch-punch.min.js"></script>
</head>

<body>
	<div id="output"></div>
</body>
<script type="text/javascript">

var tpl = $.pivotUtilities.aggregatorTemplates;
var dateFormat = $.pivotUtilities.derivers.dateFormat;

$.getJSON("/path/to/json_data.json", function(mps) {
	$("#output").pivotUI(
		mps, {
			cols: ["date"],
			rows: ["hour"],
			aggregators: {
				"Number of Errors": function() { return tpl.sum()(["nbError"]) },
				"Number of Valid": function() { return tpl.sum()(["nbValid"])}
			},
			hiddenAttributes: ["nbError", "nbValid"]
		}
	 );
});
</script>

,


Leave a Reply

Your email address will not be published. Required fields are marked *