All updates

Aggregation actions in tables

Aggregation actions in tables

Sep 15, 2024

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