compute values by summarising data from a linked collection. They are ideal for generating summary metrics, such as totals, averages, or counts, without manual calculations.

Aggregation fields enable you to:

Calculate Totals, averages & more

Aggregation Fields

Aggregation Field

A Field that summarises data (sum, average, count, etc.) from multiple linked Records via a Lookup Field.

summarise data (e.g., sum, average, count, minimum, or maximum) from related records in a linked collection.

For example: You could use an aggregation field to calculate the total length of time to build a product using linked build steps or SOPs.
Or to total the values in a quotation or Bill-of-Materials (BOM).

When setting up an Aggregation Field, you need to define:

Target Collection:

The collection from which to pull data.

Link Field:

The field that establishes a connection between the two collections.

Target Field:

(For modes other than Count) The numerical field in the target collection to use in calculations.

Mode:

The type of calculation to perform, such as:

Count:

Total number of related records.

Sum:

Total sum of a numerical field.

Average:

Mean value of a numerical field.

Min/Max:

The smallest or largest value, respectively.

Tips for Using Aggregation Fields

You can refine your aggregation by adding filters
Filter
A set of conditions applied to a Collection or View to narrow down which Records are displayed.
, ensuring that only records meeting specific criteria (e.g., only 'Completed' invoices) are included.

By mastering Aggregation Fields, you can automate calculations, averages & totals from your connected data. This keeps your Kinbabase dynamic and streamlined.

If you have questions or need further assistance, our support team is here to help.

PreviousLookup Fields

Next Adding Records