distinct(T.‘a) 🡒 number, aggregator
The aggregator indicates how many distinct elements there are. Two elements
b are considered identical if
a == b.
table T = with [| as A, as B |] [| 0, "a" |] [| 0, "a" |] [| 0, "b" |] [| 1, "b" |] [| 1, "c" |] table G[gdim] = by T.B where T.B != "c" show table "" a1b4 with gdim distinct(T.A) group by gdim
enum types. It returns
0 on empty groups.
The use of
distinct is not recommended for
text for large datasets, as this may cause performance problems. If you only need an approximation of the number of distinct values, use distinctapprox instead.
If the number of distinct values is not relevant, so much as whether it is 1 or more than 2, use the much faster areSame instead.