Skip to content

Aggregation functions

Jip Claassens edited this page Nov 2, 2025 · 11 revisions

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

  • 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.
  • 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
Clone this wiki locally