a!aggregationFields() Function

Function: a!aggregationFields()

Used to define a query against record data that performs an aggregation in a!queryRecordType(). Uses a!grouping() and a!measure() to define aggregate fields.

See also: a!queryRecordType, Measure Component, Grouping Component

Parameters

Keyword Type Description

groupings

Any Type

Fields to group by using a list of a!grouping(). Grouping functions can only be used within the context of a!queryRecordType().

measures

Any Type

Calculations to perform using a list of a!measure(). Measure functions can only be used within the context of a!queryRecordType().

Returns

Aggregation Fields

Notes

  • This configuration should always be used within the fields parameter of a!queryRecordType() to define the fields returned when aggregating data.
  • a!grouping() and a!measure() must be used to define the groupings and calculations for the charts. Also, these functions can only be defined within a!aggregationFields or within the configuration of a chart.
  • At least one grouping must be provided; adding measures is optional.
  • For each grouping or measure provided, the alias is required.
Open in Github Built: Thu, Feb 23, 2023 (02:59:22 PM)

On This Page

FEEDBACK