Pivot table javascript library
Clone or download
Latest commit 1c4438f Jun 28, 2015
Permalink
Failed to load latest commit information.
demo bordered drop target when empty Jun 15, 2015
deps added bootstrap support 90% Jan 5, 2015
dist Fix issue #12 Jun 28, 2015
src Fix issue #12 Jun 28, 2015
test orb.query finalized Jan 2, 2015
.gitignore Enhancements: Nov 16, 2014
.npmignore versioned dist structure Dec 25, 2014
LICENSE node require +browserify Dec 19, 2014
README.md Update README.md Jun 28, 2015
gulpfile.js added toolbar Jun 6, 2015
package.json homepage url. Jun 28, 2015

README.md

orb

Pivot grid javascript library.

Website: orbjs.net

Latest version: 1.0.9 (Release notes)

cdnjs: https://cdnjs.com/libraries/orb

Demo:

Demo

Features

Interactivity

  • Drag'n'drop to move fields
  • Click to sort
  • Visual filters
  • Drill down (cell double click)
  • Multiple data fields support
  • Grand totals & Sub totals
  • Sub totals expand/collapse
  • Enhanced scrolling (fixed headers)
  • Export to Excel (new in 1.0.9)
  • Fast rendering using React

Customization

  • Via code and/or toolbar
  • Data headers location
  • Grand totals visibility
  • Sub totals visibility & collapsed state
  • Data cells aggregate & format functions
  • Theming: built-in & Bootstrap

Data query

Query aggregation results with a simple API:

var orb = require('orb');
var pgrid = new orb.pgrid(config);

// query
var q = pgrid.query()
             .Manufacturer('Adventure Works')
             .Class('Economy');

1 field

q.Amount()

=> 1185.17 

List of fields

q.val('Amount', 'Q')

=> {
     Amount: 1185.17,
     Q: 44
   }

Aggregation func

builtin

q.stdev('Amount', 'Q');

=> {
     Amount: 1377.58,
     Q: 3.9
   }

custom

q.val({
    // count
    aggregateFunc: function(datafield, intersection, datasource) {
        return intersection.length;
    },
    fields: ['Amount', 'Q']
});

=> {
     Amount: 7,
     Q: 7
   }

Licence

MIT