ListAggDistinct

The ListAggDistinct function joins multiple values from a column into a list (as a single text string). Each window of values within the column is aggregated into an separate list.

📘

The ListAggDistinct function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Usage

ListAggDistinct(value, [separator], [direction])

Function arguments:

Examples

Example 1:

ListAggDistinct([Store Name])

A table contains a grouped Store State column. Outside the grouping, there are orders for stores within the state. ListAggDistinct is used to return a list of distinct store names within each state. When neither the separator or direction is specified, the distinct values in the output are separated by a comma and sorted in ascending order.

Example 2:

ListAggDistinct([Store Name], "-")

When a dash (-) is specified as the separator, each distinct value in the output is separated by a dash.

Example 3:

ListAggDistinct([Store Name], "-", "desc")

When the direction is specified as desc, the output is sorted in descending order.

Example 4:

ListAggDistinct([Store State], "\n")

When the newline character (\n) is used as the separator argument, each value is displayed on its own line if Wrap text formatting is applied to the column.