Savant

<b><code>arg</code></b>: the field to be counted.

1. <b><code>arg</code></b>: the field to be counted.

COUNT_DISTINCT(<code>Value</code>) Over (Partition by <code>Group</code>)

Counts the number of unique values in a specified field within a range or partition

COUNT DISTINCT

Find answers and get help from Intercom Support and Community Experts

Track the progress of all tickets related to your company.

{assigneeName} needs more information from you

Description	The `COUNT_DISTINCT()` function counts the number of unique values in a specified field within a range or partition. Empty values are not counted. This is useful for identifying the number of distinct entries.
Syntax	COUNT_DISTINCT(`arg`)
Output	integer