Aggregating Records with Conditions

You can aggregate records to return the values that meet the conditions you set.

1. On the project page, click the icon before the flag icon in the first row, and then click Edit records > Aggregate records with condition.
2. In the "Aggregate records with condition" dialog, select an aggregate function for each column. In this example, select Max for the Score column, and select Earliest for the ExamDate column.
   Depending on the data type of each column, the aggregate function is different.

   Data Types	Aggregate Functions
   Integer, Long, Float, Double	Min, Max, and First.
   String	First.
   Date, Time, and DateTime	First, Earliest, and Latest.
   Boolean	First.

3. The columns are sortable. Drag columns to set conditions for computation. In this example, drag the Score column from priority 3 to priority 1, and drag the ExamDate column from priority 5 to priority 2.
   Note: The aggregation is based on the priority you set. In this example, the aggregation of the ExamDate column is based on the aggregation results of the Score column.

   

4. Click OK.
   The aggregation results are displayed.