# How to calculate ,count of distinct column in kibana canvas

**URL:** https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870
**Category:** Kibana
**Tags:** canvas
**Created:** [June 9, 2019, 8:29am UTC](https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870 "2019-06-09T08:29:53Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Malini\_Sahoo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/malini_sahoo/32/46017_2.png) [@Malini\_Sahoo](https://discuss.elastic.co/u/Malini_Sahoo)
#### Post date: [June 9, 2019, 8:29am UTC](https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870/1 "2019-06-09T08:29:53Z")

</div>

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

---

<div class="post-metadata">

### Author: ![tims](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tims/32/46750_2.png) [@tims](https://discuss.elastic.co/u/tims)
#### Post date: [June 12, 2019, 7:02pm UTC](https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870/2 "2019-06-12T19:02:39Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![tims](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tims/32/46750_2.png) [@tims](https://discuss.elastic.co/u/tims)
#### Post date: [June 12, 2019, 7:12pm UTC](https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870/3 "2019-06-12T19:12:36Z")

</div>

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](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-aggs.html#sql-functions-aggs-count-distinct)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2019, 7:12pm UTC](https://discuss.elastic.co/t/how-to-calculate-count-of-distinct-column-in-kibana-canvas/184870/4 "2019-07-10T19:12:43Z")

</div>

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