S
Simpleasyty
Help Center — Footer 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

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

  1. Open Column settings → Footer aggregation.
  2. Select a function: Count, Count distinct, Sum, Avg, Min, Max, or Mode.
  3. 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. The totals row color can be configured from Formatting > Table colors > Summary rows.

At a glance

Function What it does Example (input → footer output)
Count Counts the number of rows in the table. 42 rows → 42
Count distinct Counts unique, non-blank values in the column. ["Ana","Ken","Ken","Maya"] → 3
Sum Adds all numeric values in the column. Non-numeric and 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. Works for numbers and dates. [2025-01-10, 2025-01-03, 2025-01-25] → 2025-01-03
Max Returns the largest value. Works for numbers and dates. [5000, 12000, 8000] → 12000
Mode Returns the most frequent value in the column. Useful for fields such as Status, Priority, or Owner. ["In progress","Blocked","In progress","Done"] → In progress
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.

Need another way to summarize your table?

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.