Summarising Grid Data

View as Markdown

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
Fork
  • This example demonstrates summarising in AdapTable:
    • Cell Summary: we select a cell range in Github Stars column (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
Try It Out
  • Select different cell ranges and different Summary Operations in the Cell Summary dashboard 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