count_distinct
Counts all distinct non-null grouped values.
count_distinct(xs:list) -> int
Description
Section titled “Description”The count_distinct
function returns the number of unique, non-null values in
xs
.
xs: list
Section titled “xs: list”The values to count.
Examples
Section titled “Examples”Count distinct values
Section titled “Count distinct values”from {x: 1}, {x: 2}, {x: 2}, {x: 3}summarize unique=count_distinct(x)
{unique: 3}