JavaScripting

The definitive source of the best
JavaScript libraries, frameworks, and plugins.


  • ×

    Pivot table javascript library
    Filed under 

    • 🔾29%Overall
    • 512
    • 28.8 days
    • 🕩165
    • 👥3

    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

    Show All