orb

Pivot grid javascript library.

Website: orbjs.net

Latest version: 1.0.9 (Release notes)

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

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