Summarising Grid Data
Summary
- AdapTable provides 2 ways to see summary information of Grid Data:
- Cell Summaries - provide comprehensive summary information of selected cells in AG Grid
- Row Summaries - Layout-based pinned Rows that display column summary aggregations
AdapTable provides 2 ways of summarising Grid Data - 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 a popup with different summary functions
- Edit some cell value in the numeric columns and see the Summaries update