Editing Records

In the records mode, you can use the aggregating records function to perform a computation on a record, such as getting the maximum value, average number, and the total amount.

Multiple aggregation methods are available. Different data types correspond to different aggregation methods.

Procedure

  1. On the project page, click , and then click Edit records > Aggregate records.
  2. In the Aggregate records dialog, configure an aggregation method for each column. Depending on the data type of each column, the aggregation method is different.
    Data Types Aggregation Methods
    Integer, Long, Float, Double Sum, Average, Min, Max, First, Count, and Unique.
    String First, Unique, Most frequent, and Count.
    Date, Time, and DateTime Earliest, First, Latest, and Count.
    Boolean First and Count.
  3. Click OK. The data matched the aggregation method is displayed.