nom, please more

    orb

    1.0.9 • Public • Published

    orb

    Pivot table 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

    Install

    npm i orb

    Homepage

    orbjs.net/

    DownloadsWeekly Downloads

    77

    Version

    1.0.9

    License

    MIT

    Last publish

    Collaborators

    • nnajm