Footer aggregation

In Baserow, footer aggregations play a crucial role in computing values derived from a specific field within a table.

This section covers the process of performing aggregations that help calculate these values accurately.

Overview

In Baserow, you can calculate the footer aggregate value by considering all the rows present in a grid view. This resulting value is then displayed in the footer cells for easy reference.

We perform calculations on all the data in the grid and summarize it at the bottom, providing a comprehensive overview of the data at a glance. This allows for quick evaluation and summarization of field values across a group of rows, with the exception of the lookup field.

Please note that referencing these aggregated values is not possible.

Footer aggregation

Get field summary

By default, the footer summary for each field is empty. To obtain the summary of a specific field, follow these steps:

  • In any grid view, click on the footer bar located beneath a field at the bottom of the table to choose an aggregation function
  • Select from the menu of different aggregation functions available for the selected field

enter image description here

Once you create an aggregation, the results for each field will be displayed in the footer area.

General functions

The field type will determine the kinds of footer summaries that are available. Some summary functions will appear in date, single select, single line, phone number, email, file, multiple select, formula, link to table, long text, URL, and last modified fields. These are:

  • Empty
  • Filled
  • Percent empty
  • Percent filled
  • Unique (except Link to table, file, created on and multiple select fields)

Functions for date fields

In addition to the general function, certain functions will only appear in date, last modified and created on:

  • Earliest date
  • Latest date

enter image description here

Functions for boolean fields

A special aggregation function for a boolean field allows you to see the number or percentage of checked and unchecked cells

  • Checked
  • Unchecked
  • Percent checked
  • Percent unchecked

enter image description here

Functions for number and rating fields

In addition to the general function, you can use the number field footer aggregation to calculate the sum, minimum, or maximum of numeric data in grid view columns. For numeric and rating fields:

  • Min
  • Max
  • Sum
  • Average
  • Median
  • Standard deviation
  • Variance

enter image description here

Related content

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.