Sign Up for Free

RunKit +

Try any Node.js package right in your browser

This is a playground to test code. It runs a full Node.js environment and already has all of npm’s 400,000 packages pre-installed, including orb-fix with all npm packages installed. Try it out:

var orbFix = require("orb-fix")

This service is provided by RunKit and is not affiliated with npm, Inc or the package authors.

orb-fix v2.0.4

Pivot table javascript library

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

Metadata

RunKit is a free, in-browser JavaScript dev environment for prototyping Node.js code, with every npm package installed. Sign up to share your code.
Sign Up for Free