Counts the number of distinct values that appear in a field.
Syntax
COUNT_DISTINCT(VALUE)
Arguments
VALUE: The field you want to count.
Returns
An integer
Notes
Duplicate field values are not counted.
For example: for values: "a, b, c, c, c, b" the distinct count would be 3, because the values "b" and "c" repeat and only get counted once.
NULLs are not counted.
Count the number of distinct entries for each unique entry in a field:
SELECT
COUNT(DISTINCT data.USER_ID) AS count_distinct_data_user_id:BIGINT,
data.GROUP_ID AS group_id:STRING
FROM
"SAMPLE_DATA_G1U1 - json"
GROUP BY
data.GROUP_ID
