group

DefinitionCopy Anchor Link

Group data by one or multiple dimensions. In AQL, the group function serves as an intermediate step for subsequent transformations. If used by itself, group will return a new table with all unique combination of values in the specified dimensions. To understand more about how group works, please refer to the Concepts page.

Syntax

group(table, dimension, dimension, ...)

group(products, products.category_id, products.name) // -> Table(products.category_id, products.name)

// with pipe
products | group(products.category_id, products.name) // -> Table(products.category_id, products.name)

Input

• table: A model reference or the returned table from a previous expression.
• dimension (repeatable): A fully-qualified reference to a dimension. The output table will have one row for each unique combination of values in the specified dimensions.

Output

A new table with one row for each unique combination of values in the specified dimensions.

Sample UsagesCopy Anchor Link

products | group(products.category_id, products.name) 

The special thing about group is that, it allow you to use Aggregation Functions in the context of a row of the grouped table. For example, if you want to create a table with the Total Product for each Product Category, you can use group and then use the sum function inside select to get the total product for each category:

products | group(products.category_id) | select(products.category_id, count(products.id)) 

This is especially useful when you want to create a metric with nested aggregation. For example, getting the Average of the above table:

products 
| group(products.category_id) 
| select(count_product: count(products.id)) 
| avg(count_product)

See alsoCopy Anchor Link

• select()
• filter()
• unique()
• Pipe operator