Aggregation can be used in the data fields of a user report to organize data in different ways and is a useful tool in a number of scenarios, most commonly with a custom SQL field. You can select an aggregate option for a field when creating the data fields in your user report. The most used aggregate functions are:

The min aggregate function returns the minimum non-NULL value of all values in the group. The minimum value is the first non-NULL value that would appear in the column. You may use this to find the lowest value in a list of values.

Behaves the opposite way of MIN, in that it returns the highest non-NULL value of all values in a group. Be careful when using MAX in calculations

Case when you have a collection of results which you want to count, e.g. you want to count the number of assignees on a certain policy, or from a certain location.

SUM is useful to create totals or sum totals in your reporting.