npm

npm’s 2019 JavaScript ecosystem survey analysis is now available!Get your copy here »

orb-fix

2.0.4 • Public • Published

orb

Pivot grid javascript library.

Website: WIP.

Latest version: 2.0.1

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

install

npm i orb-fix

Downloadsweekly downloads

1

version

2.0.4

license

MIT

homepage

orbjs.net

repository

Gitgithub

last publish

collaborators

  • avatar
Report a vulnerability