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.
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.
By default, the footer summary for each field is empty. To obtain the summary of a specific field, follow these steps:
Once you create an aggregation, the results for each field will be displayed in the footer area.
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:
In addition to the general function, certain functions will only appear in date, last modified and created on:
A special aggregation function for a boolean field allows you to see the number or percentage of checked and unchecked cells
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:
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.
Contact support for questions about Baserow or help with your account.