Grouping Aggregation
When grouping is active , you can apply column-level aggregation functions to control how each column summarizes its data inside each group. You can group by one column, then nest by a second, third, and so on — for example: Region → Sales Rep → Product.
In a group row, columns with an aggregation show their computed value. Non-grouped columns without an aggregation are hidden in the group header to avoid confusion.
- Turn on Grouping and choose one or more group-by columns.
- Open Column settings → Aggregation for the columns you want to summarize.
- Select a function: Sum, Avg, Min, Max, Count, Count distinct, or Mode.
- Preview results live in the group header row.
- Click Save to apply across the table.
Tip: You can mix different aggregations across columns and in nested group levels.
At a glance
| Function | Good for | Example (input → output) |
|---|---|---|
| Sum | Revenue, totals, hours | [120, 80, 50] → 250 |
| Avg | Satisfaction, scores, SLAs | [4.6, 4.9, 4.0] → 4.5 |
| Min | Fastest delivery, earliest date | [7d, 3d, 5d] → 3d |
| Max | Largest contract, latest date | [$5k, $12k, $8k] → $12k |
| Count | Tickets, items, rows | 42 rows → 42 |
| Count distinct | Unique contributors, SKUs | ["Ana","Ken","Ken","Maya"] → 3 |
| Mode | Predominant status/label | ["In progress","Blocked","In progress","Done"] → In progress |
Examples are illustrative; actual formatting follows your column type and locale.
Sum
What it does: Adds all numeric values in the group. Blank cells are ignored.
Sales Lead
KantoSoft — Sales Team
Setup: Group by “Region”; set “Revenue” aggregation to Sum.
Impact: Managers instantly see revenue per region.
Avg
What it does: Calculates the arithmetic mean of numeric values. Blanks are ignored.
HR Manager
Midori Inc — People Team
Setup: Group by “Department”; set “Score” aggregation to Avg.
Impact: Highlights teams that need attention.
Min
What it does: Returns the smallest value. Works for numbers and dates.
Logistics Ops
Nippon Express — Operations
Setup: Group by “Route”; set “Delivery Time” to Min.
Impact: Reveals benchmark routes to replicate.
Max
What it does: Returns the largest value. Works for numbers and dates.
Deals Boss
KyotoTech — Sales
Setup: Group by “Rep”; set “Contract Value” to Max.
Impact: Spotlights top deal makers.
Count
What it does: Counts rows in the group (including blanks).
Support Agent
ZenDeskura — Support
Setup: Group by “Issue Type”; set any column to Count (or use a helper column).
Impact: Guides staffing and prioritization.
Count distinct
What it does: Counts unique, non-blank values in the group.
Engineering Lead
NaraCode — DevOps
Setup: Group by “Repository”; set “Author” to Count distinct.
Impact: Encourages knowledge sharing across teams.
Mode
What it does: Returns the most frequent value in the group — ideal for categorical fields like Status, Priority, or Owner. Blanks are ignored. Tip: If there’s a tie, the result will be one of the most frequent values. For consistent outcomes, sort or add a tie-breaker column.
Project Ops
Hikari Solutions — PMO
Setup: Group by “Project”; set “Status” aggregation to Mode.
Impact: Quickly shows the predominant state of work per project (e.g., mostly “In progress”).
• Aggregations affect the group header row; underlying row values remain unchanged.
• You can mix different aggregations across columns in the same grouping level.
• Nested groupings compute aggregates at each level independently.
Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.