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' }] }
See also
- GroupSummary - Summary rows within groups
- sum - Per-column summary config
Configs
Configs are options you supply in a configuration object when creating an instance of this class-
Set to
trueto only refresh columns with fields matching the changed fields after a field updateHas a corresponding runtime refreshOnlyAffectedSummaries property.
-
Set to
trueto sum values of selected row recordsHas 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
falseto disable localization of this object.
Properties
Properties are getters/setters or publicly accessible variables on this class-
Identifies an object as an instance of Events class, or subclass thereof.
-
Identifies an object as an instance of Localizable class, or subclass thereof.
-
Identifies an object as an instance of Summary class, or subclass thereof.
-
A class property getter for the default values of internal properties for this class.
-
Set to
trueto only refresh columns with fields matching the changed fields after a field updateHas a corresponding refreshOnlyAffectedSummaries config.
-
Set to
trueto sum values of selected row recordsHas a corresponding selectedOnly config.
-
An empty array that can be used as a default value.
-
An empty object that can be used as a default value.
-
Identifies an object as an instance of InstancePlugin class, or subclass thereof.
-
Identifies an object as an instance of Summary class, or subclass thereof.
-
Returns a copy of the full configuration which was used to configure this object.
-
This property is set to
truebefore theconstructorreturns. -
This property is set to
trueon entry to the destroy method. It remains on the objects after returning fromdestroy(). If isDestroyed istrue, this property will also betrue, so there is no need to test for both (for example,comp.isDestroying || comp.isDestroyed). -
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-
This optional class method is called when a class is mixed in using the mixin() method.
-
Registers this class type with its Factory
-
onStoreChange( )private
Updates summaries on store changes (except record update, handled below)
-
refresh( )
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
-
Auto detaches listeners registered from start, if set as detachable
-
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.