Aggregating Each Column of a Record

You can perform computation on each column of a record. The aggregation of one column does not affect the aggregation of another column.

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

   Data Types	Aggregate Functions
   Integer, Long, Float, Double	Sum, Average, Min, Max, First, Unique, and Count.
   String	First, Unique, Most frequent, and Count.
   Date, Time, and DateTime	First, Earliest, Latest, and Count.
   Boolean	First and Count.

3. If you want to display the aggregate results only, keep the Remove original rows check box selected. Otherwise, clear this check box.
4. Click OK.
   If you selected the Remove original rows check box in step 3, only the aggregate results are displayed; if you cleared the Remove original rows check box in step 3, the aggregate results are displayed as the last piece of information of a record.