Summarising Grid Data
Summary
- AdapTable offers two ways to see summary information for AG Grid data:
- Cell Summaries — comprehensive summaries of the currently selected cells in numeric columns
- Row Summaries — layout-based pinned rows that show per-column aggregations over the grid
AdapTable can summarise AG Grid data through Cell Summaries and Row Summaries:
Cell Summaries
- Summarise selected Numeric Cells
- Table displays all available summaries
- AdapTable ships System Summaries
- Users can add Custom Summaries
Row Summaries
- Display Column Summary Aggregations
- Leverage AG Grid Pinned Rows
- Can be displayed at Top or Bottom of Grid
- Persisted on a per-Table Layout basis
Summarising Grid Data
- This example demonstrates summarising in AdapTable:
- Cell Summary: we select a cell range in
Github Starscolumn (using AdapTable's Grid API) and display the Sum of the values in the Cell Summary UI components - Row Summary: we provide a Row Summary (at the top) showing aggregations for 4 Columns
- Cell Summary: we select a cell range in
Try It Out
- Select different cell ranges and different Summary Operations in the
Cell Summarydashboard and see the results - Alternatively right-click and select Cell Summary to open the Cell Summary page in the Settings Panel
- Edit some cell value in the numeric columns and see the Summaries update
Loading demo…
Cell summaries require cell selection (CellSelection module and cellSelection in grid options); see Selecting Grid Data. Row summaries are part of table layout state; see Table Layouts and Summarising Technical Reference.
AdapTable Resources
- AG Grid Modules (
CellSelectionModulefor cell summaries) - Summarising Technical Reference