Supported aggregate functions

Pentaho Metadata Editor

Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA007-11
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.