Aggregating Records with Conditions

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

When the two student records are displayed, you can return the highest score with the earliest exam date.

Procedure

  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.