by
array
required

Columns to group by. An array specifying the columns used for grouping. The by parameter can be either:

  • An array of column names (e.g., ["column1", "column2"]), which defaults to EXACT grouping.
  • An array of objects with columnName, groupingType, and optional param properties.
aggregations
array[object]
required

Aggregation functions to apply. An array specifying the aggregation functions to apply on each group. The array can be empty, in which case no aggregations are performed, but the dataset is still grouped by the specified columns.