The summary bar provides different types of summarizations of all the cell values in a given field.
Special functions for numeric fields
Special functions for date fields
Special functions for attachment fields
At the bottom of the table in grid view is the summary bar.
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.
If you select a range of rows or cells, the summarization will only include cells that are in that selection range.
Certain summary functions are available in all non-calculated fields (i.e. not formula, rollup, or lookup).
They are, as follows:
- Empty
- Filled
- Percent Empty
- Percent Filled
For checkbox fields, the summary functions will display slightly differently, as Unchecked, Checked, Percent Unchecked, and Percent Checked.
For single line text, long text, single select, phone number, email, URL, date, and numerical fields, the summarization functions 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 which are unique in a field, respectively.
Special functions for numeric fields
Certain functions will only appear in numeric fields (i.e. number, currency, percent, and autonumber). These are, as follows:
- Sum
- Average
- Histogram
- Min
- Max
- Range
- Median
- Standard Deviation
Special functions for date fields
Certain functions will only appear in date fields. These are, as follows:
- Earliest Date
- Latest Date
- Date Range (months)
- Date Range (days)
Special functions 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.
