Apply an aggregate function

Pentaho Business Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17
You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value calculated from the values in a 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. These types are described in the following table:
    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
    Maximum Identifies the highest or largest value in a column
    Minimum Identifies the lowest or smallest value in a column
    Sum Calculates a running total sum of the specified column
  3. Save the report.