While Calculations are about a single entry, Aggregation is a math function applied to all entries in Library by the selected field. It helps you to find the minimal, maximal or average value or the total sum.
To add Aggregations, follow the steps below:
- Select Aggregation row in the Library. It is under all fields you’ve added
- Click
to set a new function - In the window that will be opened, set the Field you want to aggregate by
- Define the Function: Min, Max, Average, Sum
- Add Prefix — a short string that will be shown near this aggregation in Library and should be understandable for an end user
- Adjust additional parameters for specific field types
- Click OK
Here is how the Aggregations will be shown in Library:
Note that Aggregation is calculated for each Group of the Library separately.