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.

  1. 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.

  2. Click the icon to the right of the variable.

    field options when on shelf
    Accessing Field Options
  3. In the dropdown, click Aggregates.
  4. 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([field]) function, 'number of distinct values'.

      Similar to COUNT(DISTINCT([field])). See Impala NDV Function.

    • 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.

    aggregates menu
    Aggregate Options
  5. Click Refresh Visual.