Contents x
The summary bar
  • 26 Jan 2023
  • 1 Minute to read
  • Print
  • Dark
    Light
Contents

The summary bar

  • Updated on 26 Jan 2023
  • 1 Minute to read
  • Print
  • Dark
    Light

Learn about the summary bar, an Airtable base metadata feature that provides different types of summarizations of all the cell values in a given field.

Note

The summary bar is a great tool that can be used to quickly understand and calculate values for a set of records. However, the summary bar can't be referenced by Airtable records. Summary values are a type of metadata not currently accessible by record-level formulas.


Summary bar overview

The summary bar is located at the bottom of some view types within a table. Certain field types will offer different summary options. Those differences are covered in more depth below.

By default, the summary function for each numeric field is Sum, and the summary function for non-numeric fields is blank. To select a different summarization function for a specific field, click on the summary bar below that field. This will bring up a menu of different summary functions. The types of summary functions available will depend on the type of field.

Screen Recording 2020-11-10 at 09.32.45 am(1)

If you select a range of rows or cells, the summarization will only include cells that are in that selection range.

Screen Recording 2020-08-06 at 08.03.07 AM

If the records in your view are grouped then your summary bar will automatically show a separate summary for each group, as well as the total summary for the field as a whole:

image.png


General summary functions

Non-calculated fields

Certain summary functions are available in all non-calculated fields (i.e. not formula, rollup, or lookup).

image.png

They are, as follows:

  • Empty
  • Filled
  • Percent Empty
  • Percent Filled
Checkbox fields

For checkbox fields, the summary functions will display slightly differently, as Unchecked, Checked, Percent Unchecked, and Percent Checked.

image.png

Unique summaries

Many field types will also include Unique and Percent Unique. These functions allow you to calculate the absolute number of unique values present in a field, and the percentage of cell values that are unique in a field, respectively.

image.png


Special functions for numeric fields

Special functions for numeric fields

Certain functions will only appear in numeric fields (i.e. number, currency, percent, and autonumber).

  • Sum
  • Average
  • Histogram
  • Min
  • Max
  • Range
  • Median
  • Standard Deviation

image.png

Special functions for date fields

Certain functions will only appear in date fields. These are, as follows:

  • Earliest Date
  • Latest Date
  • Date Range (days)
  • Date Range (months)

image.png

Special function for attachment fields

A special summary function for an attachment field allows you to see the total size of the file attachments in the attachment field, in bytes.

image.png


Was this article helpful?
What's Next