/orb

Pivot table javascript library

Primary LanguageJavaScriptMIT LicenseMIT

orb

Pivot grid javascript library.

Website: https://nnajm.github.io/orb/

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