Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 

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


[1] Maximum of column.

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



[2] 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



[3] 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