- ×
Pivot table javascript library
Filed under dataShow Allorb
Pivot grid javascript library.
Website: https://nnajm.github.io/orb/
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