Aggregation actions in tables
Sep 15, 2024
This update brings new powerful aggregations to our data table footer, allowing you to easily view the number of documents, averages and sums and much more. If you're familiar to Notion you'll feel right at home with this update.
Added aggregations to table footer
Count all: Get a tally of all documents in a view
Count empty: Count the number of documents where that field is empty
Count non empty: Count the number of documents where that field is not empty
Percent empty: Percent of the documents where that field is empty
Percent non empty: Percent of the documents where that field is not empty
Average: Calculate mean values for numerical fields
Sum: Total up numerical fields
Minimum: Lowest value for numerical fields
Maximum: Highest value for numerical fields
Earliest date: Earliest date value for timestamp fields
Latest date: Most recent date value for timestamp fields
Date range: Time between earliest and latest dates for timestamp fields