v7.3.0
SupportExamplesFree Trial

Summary
Feature

Displays a summary row in the grid footer.

targetElement.innerHTML = '<p>Specify type of summary on a column to have it displayed in the footer</p>'; const grid = new Grid({ appendTo : targetElement, // makes grid as high as it needs to be to fit rows autoHeight : true, features : { // enable summaries summary : true }, data : DataGenerator.generateData(5), columns : [ { field : 'name', text : 'Name', flex : 1 }, { type : 'number', field : 'score', text : 'Score', flex : 1, sum : 'sum' }, { type : 'number', field : 'rank', text : 'Rank', flex : 1, sum : 'average' } ] });

On each column you can specify the type of sum, available types are:

Type Description
sum Sum of all values in the column
add Alias for sum
count Number of rows
countNotEmpty Number of rows containing a value
average Average of all values in the column
function A custom function, used with store.reduce. Should take arguments (sum, record)

Columns can also specify a summaryRenderer to format the calculated sum.

This feature is disabled by default.

{ text : 'Score', data : 'score', width : 80, sum : 'sum' }
{ text : 'Rank', data : 'rank', width : 80, sum : 'average', summaryRenderer: ({ sum }) => return 'Average rank ' + sum }

Also, it is possible to set up multiple summaries as array of summary configs:

{ text : 'Rank', data : 'rank', summaries : [{ sum : 'average', label : 'Average' }, { sum : 'count', label : 'Count' }] }

When Store has lazyLoad, this feature will only work on locally available data

See also

  • GroupSummary - Summary rows within groups
  • sum - Per-column summary config
No results

Configs

Configs are options you supply in a configuration object when creating an instance of this class
  • Set to true to only refresh columns with fields matching the changed fields after a field update

    Has a corresponding runtime refreshOnlyAffectedSummaries property.

  • Set to true to sum values of selected row records

    Has a corresponding runtime selectedOnly property.

  • Internal listeners, that cannot be removed by the user.

  • The widget which this plugin is to attach to.

    Has a corresponding runtime client property.

  • Set to false to disable localization of this object.

Properties

Properties are getters/setters or publicly accessible variables on this class
  • isEvents : Booleantrue
    READONLY
    static
    ADVANCED
    Events
    Identifies an object as an instance of Events class, or subclass thereof.
  • isLocalizable : Booleantrue
    READONLY
    static
    ADVANCED
    Localizable
    Identifies an object as an instance of Localizable class, or subclass thereof.
  • isSummary : Booleantrue
    READONLY
    static
    ADVANCED
    Identifies an object as an instance of Summary class, or subclass thereof.
  • properties : Object
    internal
    static
    InstancePlugin

    A class property getter for the default values of internal properties for this class.

  • Set to true to only refresh columns with fields matching the changed fields after a field update

    Has a corresponding refreshOnlyAffectedSummaries config.

  • Set to true to sum values of selected row records

    Has a corresponding selectedOnly config.

  • emptyArray : Array
    internal
    READONLY
    InstancePlugin

    An empty array that can be used as a default value.

  • emptyObject : Object
    internal
    READONLY
    InstancePlugin

    An empty object that can be used as a default value.

  • isInstancePlugin : Booleantrue
    READONLY
    ADVANCED
    InstancePlugin
    Identifies an object as an instance of InstancePlugin class, or subclass thereof.
  • isSummary : Booleantrue
    READONLY
    ADVANCED
    Identifies an object as an instance of Summary class, or subclass thereof.
  • config : Object
    READONLY
    ADVANCED
    InstancePlugin

    Returns a copy of the full configuration which was used to configure this object.

  • This property is set to true before the constructor returns.

  • isDestroying : Boolean
    READONLY
    ADVANCED
    InstancePlugin

    This property is set to true on entry to the destroy method. It remains on the objects after returning from destroy(). If isDestroyed is true, this property will also be true, so there is no need to test for both (for example, comp.isDestroying || comp.isDestroyed).

  • client : Widget
    READONLY
    ADVANCED
    InstancePlugin

    The Widget which was passed into the constructor, which is the Widget we are providing extra services for.

    Has a corresponding client config.

  • Get the global LocaleHelper

  • Get the global LocaleManager

Functions

Functions are methods available for calling on the class
  • onClassMixedIn( )
    internal
    static
    InstancePlugin

    This optional class method is called when a class is mixed in using the mixin() method.

  • initClass( )
    static
    ADVANCED
    InstancePlugin

    Registers this class type with its Factory

  • onStoreChange( )
    private

    Updates summaries on store changes (except record update, handled below)

  • Refreshes the summaries

  • refreshSummaries( )
    private

    Updates summaries. Summaries are displayed as tables in footer (styling left out to keep brief):

    <table>
        <tr><td colspan="2">0</td></tr> // { sum : 'min' } Only a calculation, span entire table
        <tr><td>Max</td><td>10</td></tr> // { sum : 'max', label: 'Max' } Label + calculation
        <tr><td>Max</td><td>10</td></tr> // { sum : 'sum', label: 'Max' } Label + calculation
    </table>
  • Internal function used to hook destroy() calls when using thisObj

  • Internal function used restore hooked destroy() calls when using thisObj

  • doDestroy( )
    internal
    Events

    Auto detaches listeners registered from start, if set as detachable

  • once( )
    private
    Events

    Internal function used to run a callback function after an event is triggered

  • Removes all listeners registered to this object by the application.

  • This will merge a feature's (subclass of InstancePlugin) keyMap with it's client's keyMap.

Events

Events are triggered for certain actions in this class and can be listened for to react to those actions in your code

Event handlers

Event handlers are callbacks called as a result of certain actions in this class

Type definitions

id: summary

Source path

Grid/feature/Summary.js

Demo

examples/features

Contents