Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 

Description

This function calculates the maximum value per group. MAX can be applied on any data type.

Syntax

MAX ( table.column )

Null handling

Null values are ignored, meaning that they don't influence the result. If all values of a group are null, the result for this group is also null.

Examples

Maximum of column.
Query
Column1
MAX ( "Table"."Column" )
Input
Table
Column : INT
1
-3
4
Output
Result
Column1 : INT
4



Get the maximum value by country.
Query
Column1
"Table"."Country"
Column2
MAX ( "Table"."Values" )
Input
Table
Country : STRINGValues : INT
'US'
3
'DE'
10
'DE'
5
'FR'
5
'US'
4
'US'
3
Output
Result
Column1 : STRINGColumn2 : INT
'DE'
10
'FR'
5
'US'
4



Get the maximum value mixed with nulls, grouped by country.
Query
Column1
"Table"."Country"
Column2
MAX ( "Table"."Values" )
Input
Table
Country : STRINGValues : INT
'FR'
10
'FR'
null
'DE'
null
Output
Result
Column1 : STRINGColumn2 : INT
'DE'
null
'FR'
10



  • No labels