--- title: "array:aggregate — Aggregate array items" description: "iXML command array:aggregate: Aggregate array items." canonical_url: "https://www.zeyos.com/ixml/ref/array-aggregate" markdown_url: "https://www.zeyos.com/ai/guide/ixml/ref/array-aggregate.md" section: "ixml-reference" authority: "reference" language: "en" source_repository: "https://cloud.zeyos.com/__doc/ixmldoc.xml" source_sha256: "a23f04e6a98628ca3c273c3b8dd2c33c034cfda3e0f00478d8793074fd2f70dd" --- # array:aggregate — Aggregate array items ARRAY:AGGREGATE calculates an aggregated value of the values of an array based on a given aggregation type. A given key may specify the column of a multidimensional array to aggregate by. If however, the key is omitted, then the array is treated as an unidimensional list. ### Attributes | Name | Type | Default | Description | | ---- | ---- | ------- | ----------- | | var | var | | Variable name | | var_result | var | | Result variable name | | type | type | count | Aggregation type | #### Possible values Possible values for `type`: - count — Count - sum — Summation - avg — Average - product — Product - min — Minimum - max — Maximum - range — Range - median — Median - mean-arith — Arithmetic mean - mean-geo — Geometric mean - mean-harm — Harmonic mean - mean-sqr — Square mean - stddev-pop — Population standard deviation - stddev-samp — Sample standard deviation - var-pop — Population variance - var-samp — Sample variance ### Children - (none) ### Parents - (not restricted in the reference) ### Result - binding: var_result; type: n/a ### Examples ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ``` ```xml 16 32 19 57 62 48 ```