Field Summary

Field Summaries are used to summarize field values within a Grid View. These summaries provide valuable insights into your data at a glance. You can think of Field Summaries as pre-built functions that you can apply to each field.

Field Summaries are contextual to each field type and provide different options for aggregating, calculating, and evaluating field values. These can be sums, averages, or even total values that tell you how many rows are filled or empty.

In Baserow, Field Summaries play a crucial role in computing values derived from a single field in a table. This section covers the process of using Field Summaries in your Baserow database.

Overview

In Baserow, you can select the Field Summary option in any Grid View. The resulting value is displayed at the bottom of its respective field for easy reference.

Note 1: Referencing Field Summary values is not possible. Note 2: Field Summaries do not work for Lookup fields.

Get a Field Summary

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

1. Navigate to the Grid View you want to work in.
2. Look for the portion of the screen that contains the number of rows in your view. This is the footer.
3. Within the footer, hover over and click on any footer cell located beneath the field.
4. A menu listing available Field Summaries will appear. Select any Field Summary (e.g., Sum, Average, Min, Max, Unique, Percent empty, etc.) to apply it to that particular field.

Once you’ve chosen a Field Summary, the corresponding value will be displayed in the field’s footer. This value will automatically update whenever the data in the table changes.

Field Summaries in Public Grid Views

When you share a Grid View publicly, any Field Aggregations you’ve applied will also be visible to your viewers. This helps present summarized information.

Note: Only Field Summaries you have explicitly set will be displayed. There are no Field Summaries applied by default.

Types of options in Field Summaries

The field type will determine the kinds of Field Summaries that are available. Some functions will appear in Date, Single Select, Single Line Text, Phone Number, Email, File, Multiple Select, Formula, Link To Table, Long Text, URL, Created On, and Last Modified By fields. These are:

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

Options 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

Options for Boolean fields

A Field Summary that’s particular to Boolean fields allows you to see the number or percentage of checked and unchecked cells.

• Checked
• Unchecked
• Percent checked
• Percent unchecked

Options for Number and Rating fields

In addition to the general options available, you can use the Field Summaries in a Number field to calculate a few different values. For the Number and Rating fields, these are the options available:

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

Related content

• Work with Grid Views.
• Create a field.
• Field configuration options.

---

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.