# Is it possible to use field exists Canvas essql?

**URL:** https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624
**Category:** Kibana
**Created:** [May 21, 2021, 7:06am UTC](https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624 "2021-05-21T07:06:03Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![thirukumaran09](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@thirukumaran09](https://discuss.elastic.co/u/thirukumaran09)
#### Post date: [May 21, 2021, 7:06am UTC](https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624/1 "2021-05-21T07:06:03Z")

</div>

Hi!

I am trying to use Canvas to build a Dashboard to show the Metrics based on certain field availability.

Is it possible to use the exists function in essql? Or is there any alternative functions available to execute in essql?

`SELECT AVG(METRICS-NAME) FROM index WHERE field_name exists and <other_conditions>`

**Note:** I have tried the Kibana visualization - where "field exists" filter is available. But I would like to know we can use "exists" in Canvas.

Thank you!

---

<div class="post-metadata">

### Author: ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)
#### Post date: [May 21, 2021, 8:43am UTC](https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624/2 "2021-05-21T08:43:58Z")

</div>

Hi

what about using `where <fieldname> is not null`?

---

<div class="post-metadata">

### Author: ![thirukumaran09](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@thirukumaran09](https://discuss.elastic.co/u/thirukumaran09)
#### Post date: [May 23, 2021, 2:02pm UTC](https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624/3 "2021-05-23T14:02:46Z")

</div>

Hi There!

Thanks a lot for sharing this. Lately, we managed to check the field which contains blank value. Tried the other way, `where "<fieldname>"=''` and the condition worked as expected.

---

<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: [June 20, 2021, 2:03pm UTC](https://discuss.elastic.co/t/is-it-possible-to-use-field-exists-canvas-essql/273624/4 "2021-06-20T14:03:42Z")

</div>

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