Footer Aggregation

Add automatic aggregations to the footer row of your table. Footer aggregations summarize column values and display the result beneath the table.

They are useful when you want a quick overall summary of the current table without enabling grouping.

Quick guide

Open Column settings → Footer aggregation.
Select a function: Count, Count distinct, Sum, Avg, Min, Max, or Mode.
Review the result in the footer and click Save.

Tip: Footer aggregations summarize the current table view and are shown in the footer row only.

At a glance

Function	Good for	Example (input → footer output)
Count	Tickets, rows, items	`42 rows` → 42
Count distinct	Unique users, SKUs, labels	`["Ana","Ken","Ken","Maya"]` → 3
Sum	Revenue, hours, totals	`[120, 80, 50]` → 250
Avg	Satisfaction, score, SLA	`[4.6, 4.9, 4.0]` → 4.5
Min	Earliest date, fastest time	`[2025-01-10, 2025-01-03, 2025-01-25]` → 2025-01-03
Max	Latest date, largest amount	`[5000, 12000, 8000]` → 12000
Mode	Predominant status or label	`["In progress","Blocked","In progress","Done"]` → In progress

Examples are illustrative. Actual formatting follows your column type and display settings.

Count

What it does: Counts the number of rows in the table.

Use case: Tickets in queue

Queue Manager

ZenDeskura — Support

Setup: Set the Ticket ID column footer to Count.

Impact: Shows the total number of items to review at a glance.

Count distinct

What it does: Counts unique, non-blank values in the column.

Use case: Unique SKUs sold

Merch Ops

Kyoto Retail

Setup: Set the SKU column footer to Count distinct.

Impact: Helps show catalog breadth for the selected dataset.

Sum

What it does: Adds all numeric values in the column. Non-numeric and blank values are ignored.

Use case: Monthly spend

Budget Analyst

Acme Co — Finance

Setup: Set the Amount column footer to Sum.

Impact: Provides a total without leaving the page.

Avg

What it does: Calculates the arithmetic mean of numeric values. Blank values are ignored.

Use case: Average satisfaction

HR Manager

Midori Inc — People Team

Setup: Set the Score column footer to Avg.

Impact: Gives a quick overall average for the visible dataset.

Min

What it does: Returns the smallest value. Works for numbers and dates.

Use case: Earliest deadline

Project Planner

Hikari Solutions

Setup: Set the Due date column footer to Min.

Impact: Keeps the earliest value visible in the footer.

Max

What it does: Returns the largest value. Works for numbers and dates.

Use case: Largest contract

Deals Boss

KyotoTech — Sales

Setup: Set the Contract value column footer to Max.

Impact: Highlights the largest value in the table.

Mode

What it does: Returns the most frequent value in the column. This is useful for categorical fields such as Status, Priority, or Owner.

If there is a tie, the result will be one of the most frequent values. Blank values are ignored.

Use case: Predominant status

Project Ops

Hikari Solutions — PMO

Setup: Set the Status column footer to Mode.

Impact: Gives a quick read of the predominant state of the visible rows.

Notes
• Footer aggregations summarize the column in the footer area; underlying row values remain unchanged.
• Different columns can use different footer functions in the same table.
• Footer aggregations work together with your chosen data types and display formats.

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