Skip to main content
Pentaho Documentation

Supported Aggregate Functions

The table below contains a listing of supported aggregate functions.

Function Name Description
SUM Sums a specific columns values determined by grouping
COUNT Counts a specific columns values determined by grouping
AVG Averages a specific columns values determined by grouping
MIN Selects the minimum column value determined by grouping
MAX Selects the maximum column value determined by grouping