Get new jQuery plugins just once a week

×

Pivot-js

FavoriteLoadingAdd to favorites

July 6, 2012

Pivot-js |A jquery plugin to summarize large data sets

Pivot.js is a jquery plugin to summarize large data sets on the fly.The data for the chart is based on a CSV file of about 5000 rows. It is generated by a script included in the repository. It is designed to have many fields that have at least some significant relationships between one another.It allows for the creation of highly customizable unique table views from your browser.
Created by Robert Jackson

Download

Example

pivot-js-jquery-plugin

Pivot.js is a jquery plugin to summarize large data sets on the fly for about 5000 rows

Welcome to Pivot.js

Pivot.js is a simple way for you to get to your data. It allows for the creation of highly customizable unique table views from your browser.

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data.

In our case, results (or the pivot-table) will be displayed as an HTML table pivoting from the input data (CSV or JSON). Without further ado let's get to usage.

View an example or view the Docs for more information.

Usage

Step one is to initialize the pivot object. It expects the following attributes:

 [ {name: 'header-name', type: 'string', optional_attributes: 'optional field' },
 {name: 'header-name', type: 'string', optional_attributes: 'optional field' }]

(See more about fields in Section below)

{zip_code: '34471'}

Those are the options that you should consider. There are other options that are well covered in the spec.

A valid pivot could then be set up from like so.


var field_definitions = [{name: 'last_name', type: 'string', filterable: true}, {name: 'first_name', type: 'string', filterable: true}, {name: 'zip_code', type: 'integer', filterable: true}, {name: 'pseudo_zip', type: 'integer', filterable: true }, {name: 'billed_amount', type: 'float', rowLabelable: false}, {name: 'last_billed_date', type: 'date', filterable: true} // from csv data: var csv_string = "last_name,first_name,zip_code,billed_amount,last_billed_date\n" + "Jackson,Robert,34471,100.00,\"Tue, 24 Jan 2012 00:00:00 +0000\"\n" + "Jackson,Jonathan,39401,124.63,\"Fri, 17 Feb 2012 00:00:00 +0000\"" pivot.init({csv: csv_string, fields: field_definitions}); // from json data: var json_string = '[["last_name","first_name","zip_code","billed_amount","last_billed_date"],' + ' ["Jackson", "Robert", 34471, 100.00, "Tue, 24 Jan 2012 00:00:00 +0000"],' + ' ["Smith", "Jon", 34471, 173.20, "Mon, 13 Feb 2012 00:00:00 +0000"]]' pivot.init({json: json_string, fields: field_definitions});

Wiki

Articles

Authors

Pivot.js is the work of Robert Jackson and Jonathan Jackson.

License

This software is licensed under a modified BSD license.

See LICENSE for more details.

Pivot-js

Related posts:

Grid Forms
DateTimePicker
Multi-Column-Select
pivot-js-jquery-plugin

http://jquer.in/wp-content/uploads/2012/07/pivot-js.png

jQuery plugin

Sign up for our weekly newsletter.

* We won't spam you ever