Aggregate functions calculate a return value across all the items in a result set. Arcadia Data provides optional aggregation operations on data values, such as summation, string concatenation, and common statistical measurements of data.

To use an aggregate functions, follow these steps.

When creating or editing a visual, determine for which field variable you must adjust aggregation.

The shelves that support aggregation depend on the visual type, and are typically available for X and Y axes, Measures, Dimensions, Colors, and Tooltips.

Click the icon to the right of the variable.

- In the dropdown, click Aggregates.
From the Aggregates menu, select one of the following options:

Sum is the summation over specified data.

Returns the value of

`SUM([`

.*field*])Count counts the records of specified data.

Returns the value of

`COUNT([`

.*field*])Approx Distinct Count returns the value of

`NDV([`

function, 'number of distinct values'.*field*])Similar to

`COUNT(DISTINCT([`

. See Impala NDV Function.*field*]))Exact Distinct Count returns the value of

`COUNT(distinct([`

.*field*]))Minimum returns the value of

`MIN([`

.*field*])Maximum returns the value of

`MAX([`

.*field*])Average returns the value of

`AVG([`

.*field*])String Concat returns the value of

`GROUP_CONCAT([`

.*field*])It is a single string representing the argument value concatenated together for each row of the result set. If specifying optional separator (usually comma followed by a space), it appears between each pair of concatenated values.

Remove Aggregate removes all of the above.

- Click Refresh Visual.