S
Simpleasyty
Help Center — Grouping aggregation
INTRO
IntroductionInstall the appQuick startRuns on Atlassian
DATA PERSISTENCE
No data egressData residency
DATA SOURCES
Data sourcesImported dataSave as AttachmentConfluence ContentPage PropertiesNative Confluence tablesTable Excerpt / Include
DISPLAY
Display settingsSearchFiltersSortingGroupingRow numbersFull screen modeDownload tableConfidential labelRovo
COLUMNS
ReorderingRename headingHideIncognito modeText appearanceColumn colorsData typeGrouping aggregationFooter aggregationCalculated columnExpression functionsUse casesNested JSON fieldsDelete column
PIVOT TABLES
Overview
FORMATTING
Layout & spacingTable colorsTable heightPagination

Grouping Aggregation

When grouping is active , you can apply aggregation functions to individual columns to control how values are summarized inside each group.

For example, you can group first by Region, then by Sales Rep, then by Product. Aggregations are calculated independently at each grouping level.

In group rows, columns with an aggregation display their summarized value. Columns that are neither grouped nor aggregated are hidden in the group header row to avoid misleading output.

Quick guide

  1. Enable Grouping and choose one or more group-by columns.
  2. Open Column settings → Aggregation for each column you want to summarize.
  3. Select one of the available functions: Sum, Avg, Min, Max, Count, Count distinct, or Mode.
  4. Review the result in the group header row.
  5. Click Save to apply the configuration.

Tip: Different columns can use different aggregation functions within the same grouped table.

At a glance

Function What it does Example (input → output)
Sum Adds all numeric values in the group. Blank values are ignored. [120, 80, 50] → 250
Avg Calculates the arithmetic mean of numeric values. Blank values are ignored. [4.6, 4.9, 4.0] → 4.5
Min Returns the smallest value in the group. Works well for numbers and dates. [7, 3, 5] → 3
Max Returns the largest value in the group. Works well for numbers and dates. [5000, 12000, 8000] → 12000
Count Counts the number of rows in the group. 42 rows → 42
Count distinct Counts unique, non-blank values in the group. ["Ana","Ken","Ken","Maya"] → 3
Mode Returns the most frequent value in the group. Useful for fields such as Status, Priority, or Owner. Blank values are ignored. ["In progress","Blocked","In progress","Done"] → In progress
Notes

• Aggregations only affect the group header row. Underlying row values are unchanged.

• Different columns can use different aggregation functions in the same grouped table.

• Nested grouping calculates aggregations independently at each grouping level.

Need another way to summarize grouped data?

Can’t find the aggregation you need? Tell us what you are trying to summarize. We build new functions from real customer requests and will look at implementing yours.

Request an aggregation

Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.