Skip to main content
Pentaho Documentation

Apply an Aggregate Function

You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value (for example, Average, Maximum, Minimum), calculated from the values in a column. For example, the sum of a column results from adding all the values in the column.

  1. Click the down arrow next to a report column that contains numeric values.
  2. Select Aggregation from the menu, then choose the aggregation type.
    Function Name Description
    None No aggregate function assigned
    Average Calculates the average value in a given column
    Count Counts the items in a column; does not require a numeric value
    Count Distinct Counts the distinct occurrences of a certain value in a column; does not require a numeric value
    Max Identifies the highest or largest value in a column
    Min Identifies the lowest or smallest value in a column
    Sum Calculates a running total sum of the specified column

    The values in the column update.

  3. Save the report.