# Can't show distinct value in canvas

**URL:** <https://discuss.elastic.co/t/cant-show-distinct-value-in-canvas/345552>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [October 23, 2023, 9:21am UTC](https://discuss.elastic.co/t/cant-show-distinct-value-in-canvas/345552 "2023-10-23T09:21:52Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![fay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fay/32/122632_2.png) [@fay](https://discuss.elastic.co/u/fay)\
**Post date:** [October 25, 2023, 11:42am UTC](https://discuss.elastic.co/t/cant-show-distinct-value-in-canvas/345552/4 "2023-10-25T11:42:26Z")

</div>

> [@Group by query with select case when gives error: Connot use non-grouped column (Canvas elasticsearch sql)](https://discuss.elastic.co/t/group-by-query-with-select-case-when-gives-error-connot-use-non-grouped-column-canvas-elasticsearch-sql/315880):
>
> Hello everyone I face a problem with a certain group by elasticsearch sql query when i try to use a field in select case condition but not group by it because it doubles my rows and leaves null values, i get the following error: [image]

my issue looks like this issue

---

_[View the full topic](https://discuss.elastic.co/t/cant-show-distinct-value-in-canvas/345552)._