Last updated
Was this helpful?
Last updated
Was this helpful?
The approximate number of distinct values in the time window.
Use this function instead of COUNT_DISTINCT
to improve performance. This should be used when there are relatively few (under 1 million) rows, and where the total number of distinct values is high.
APPROX_COUNT_DISTINCT(VALUE)
VALUE:
Can be of any type
An integer.
Duplicate rows are not counted. NULLs are not counted.
Count the number of distinct entries for each unique entry in a field: