Hi all. I have a field called TaskAction that has some 400 values. But, I only want the distinct values of that field.
Plz help me with the query.
There's dedup, and there's also the stats operator values.
values
View solution in original post
This seems to work when trying to find unique values for a field, like 'host': * | chart count by host
stats values(field) is what I used.
stats values(field)