How to calculate ,count of distinct column in kibana canvas

hi, how to calculate ,count of distinct column in kibana canvas ?

It looks like the DISTINCT keyword is not implemented in essql so you can't use it in Canvas at this time. Could you do a COUNT(*) and then group by another field to get distinct values?

Actually I was wrong, you should be able to use COUNT(DISTINCT field_name). https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-aggs.html#sql-functions-aggs-count-distinct

1 Like