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
   }

Fields can have an option dataRowColumn. dataRowColumn is optional and default value is "data row column". You can set it as either "data" "row" "column" or its combination separated by space. This will specify field is for data , row or column

Licence

MIT