# Canvas average values getting error

**URL:** https://discuss.elastic.co/t/canvas-average-values-getting-error/344660
**Category:** Kibana
**Tags:** canvas, visualisation
**Created:** [October 9, 2023, 1:24pm UTC](https://discuss.elastic.co/t/canvas-average-values-getting-error/344660 "2023-10-09T13:24:11Z")
**Posts on this page:** 1
**Showing post:** 3

<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, 7:20am UTC](https://discuss.elastic.co/t/canvas-average-values-getting-error/344660/3 "2023-10-25T07:20:59Z")

</div>

Hi jsanz  
Thank you for your reply  
I have another issue if you can help with it please

> [@Can't show distinct value in canvas](https://discuss.elastic.co/t/cant-show-distinct-value-in-canvas/345552):
>
> Hi, I want to write a sql query to show distinct value in Markdown I got the value as a table but its duplicate so I want to show the distinct value only! I try to write SELECT DISTINCT "Field\_name" from "index\_name" but I got an error that elastic doesn't support SELECT DISTINCT yet! also tried SELECT last\_value (DISTINCT "Field\_name" ) from "index\_name" I got an error ( cannot use distinct on non sql function last\_value any help please ?

---

_[View the full topic](https://discuss.elastic.co/t/canvas-average-values-getting-error/344660)._