Aggregation functions

Aggregation functions are used to aggregate data items between different domain units.

• Count
• Sum
• Mean
• minimum
• maximum
• min_ifdefined - (20.10.0 and later) minimum of the defined values, null for groups without any defined value
• max_ifdefined - (20.10.0 and later) maximum of the defined values, null for groups without any defined value
• min_alldefined - (20.10.0 and later) minimum, null for groups with any null value (or without values)
• max_alldefined - (20.10.0 and later) maximum, null for groups with any null value (or without values)
• First
• Last
• Modus
• Modus_weighted
• modus_count
• unique_count
• entropy
• average_entropy

• Nth_element - nth element of an ascending sorted attribute
• Nth_element_weighted - rank value based on the ascended weighted attribute
• Rth_element - the r * (n-1)th elements of the ascending sorted attribute. N.B. use this operator for the median.

• sd - standard deviation
• var - variance
• standard deviance(sd) - (alternative page)
• (var)iance - (alternative page)
• (corr)elation
• (cov)ariance

• All
• Any
• has_any

• Pcount - count the number of entries of a relation in the related domain
• pcount_uint8 - is the Pcount variant resulting in uint8 data item
• pcount_uint16 - is the Pcount variant resulting in uint16 data item
• pcount_uint32 - is the Pcount variant resulting in uint32 data item
• Mapping_count - count the number of cells of a grid unit in another grid unit
• Reg_count - count the non null values of an attribute towards a regional level

• Min_index - index number of the minimum value of the non null values

• Max_index - index number of the maximum value of the non null values

• as_unique_list
• as_unique_list_with_null
• frequency_table
• frequency_table_with_null