Footer Aggregation

Add automatic aggregations to the footer row of your table. Once enabled, Simple Tables computes results instantly and displays them beneath the table — updating as your data changes.

Quick guide
  1. Open Column settings → Footer aggregation.
  2. Select a function: Count, Count distinct, Sum, Avg, Min, Max, or Mode.
  3. Preview the result in the footer and click Save.

Tip: Footer aggregations summarize the column across the table and update when rows or values change.

Count
Total number of rows
Count distinct
Unique non-blank values
Sum
Add all numeric values
Avg
Average of numeric values
Min
Smallest value (numbers or dates)
Max
Largest value (numbers or dates)
Mode
Most frequent value (Moda)

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 [$5k, $12k, $8k] → $12k
Mode Predominant status/label ["In progress","Blocked","In progress","Done"] → In progress

Examples are illustrative; actual formatting follows your column types and locale.

Count

What it does: Counts the number of rows in the table (including duplicates and blanks).

Use case: Tickets in queue
avatar

Queue Manager

ZenDeskura — Support

Setup: Set the “Ticket ID” column footer to Count.

Impact: Shows the total items to triage at a glance.

Count distinct

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

Use case: Unique SKUs sold
avatar

Merch Ops

Kyoto Retail

Setup: Set the “SKU” column footer to Count distinct.

Impact: Instantly shows catalog breadth per report period.

Sum

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

Use case: Monthly spend
avatar

Budget Analyst

Acme Co — Finance

Setup: Set the “Amount” column footer to Sum.

Impact: Provides total spend without leaving the page.

Avg

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

Use case: Average satisfaction
avatar

HR Manager

Midori Inc — People Team

Setup: Set the “Score” column footer to Avg.

Impact: Tracks sentiment shifts month-over-month.

Min

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

Use case: Earliest deadline
avatar

Project Planner

Hikari Solutions

Setup: Set the “Due date” column footer to Min.

Impact: Keeps the nearest deadline visible at all times.

Max

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

Use case: Largest contract
avatar

Deals Boss

KyotoTech — Sales

Setup: Set “Contract value” footer to Max.

Impact: Highlights the biggest win on the page.

Mode

What it does: Returns the most frequent value (Moda) in the column — ideal for categorical fields like Status, Priority, or Owner. Ties return one of the most frequent values; blanks are ignored.

Use case: Predominant status
avatar

Project Ops

Hikari Solutions — PMO

Setup: Set the “Status” column footer to Mode.

Impact: Gives stakeholders a one-glance read of the overall state (e.g., mostly “In progress”).

Notes
• Footer aggregations summarize the column in the footer area; underlying row values remain unchanged.
• Mix different functions across columns to build a compact summary bar.
• Works together with your chosen data types and number/date formats.

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