MIN

Celonis Product Documentation

This function calculates the minimum value per group. MIN can be applied on any data type.

 MIN ( table.column )

NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL.

[1]

Minimum of column.

Query

Column1

         MIN ( "Table"."Column" )

Input

Output

Table

Result

Column1 : int
-3

[2]

Get the minimum value by country.

Query

Column1

         "Table"."Country"

Column2

         MIN ( "Table"."Values" )

Input

Output

Table

Result

[3]

Get the minimum value mixed with nulls, grouped by country.

Query

Column1

         "Table"."Country"

Column2

         MIN ( "Table"."Values" )

Input

Output

Table

Result

Column1 : string	Column2 : int
'DE'	null
'FR'	10

Celonis Product Documentation