Selection AggregatesPremium
The Grid enables you to select single or multiple cells or rows and calculate different metrics based on the selected data.
Start Free Trial
This functionality allows you to get a quick snapshot of some of the more important aggregates of the selected data. You can use the built-in approach and display these metrics at the bottom of the Grid or create your own elements that would display the data.
The Grid supports the following built-in aggregation for all selected cells:
max—the greatest number. Valid for numeric fields.min—the smallest number. Valid for numeric fields.sum—the sum of all numbers. Valid for numeric fields.average—the average of all numbers. Valid for numeric fields.count—the total number of cells.earliest—the earliest date. Valid forDatefields.latest—the latest date. Valid forDatefields.isTrue—the total number of boolean fields withtruevalue.isFalse—the total number of boolean fields withfalsevalue.
To enable the selection aggregates of the Grid enable its selectable prop, add a StatusBar component and update its data based on its current selection of the component kept inside its built-in select state.
The following example demonstrates selection aggregates in the Grid, where a status bar displays computed values (such as sum, average, and count) for the currently selected cells.