Package Exports

@x3platform/xmorb

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@x3platform/xmorb) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

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