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
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 a popup with different summary functions
  • Edit some cell value in the numeric columns and see the Summaries update