COUNT_DISTINCT
Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Aggregator

Function: COUNT_DISTINCT

Syntax: COUNT_DISTINCT(field|expression)

Description: Counts the number of unique values for the provided field/expression, for each grouping (set of dimensions).

Sample usage:

  • COUNT_DISTINCT(author_username) counts the number of unique authors for each grouping.

  • COUNT_DISTINCT(project_name) returns the number of unique projects for each grouping.

Did this answer your question?