How to calculate ,count of distinct column in kibana canvas

Elastic Stack Kibana
1

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

2

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?

3

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
4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.