# Lucene query is giving error in canvas metric

**URL:** <https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624>\
**Category:** Kibana\
**Created:** [January 10, 2020, 3:31pm UTC](https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624 "2020-01-10T15:31:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![anjilinga](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anjilinga/32/86010_2.png) [@anjilinga](https://discuss.elastic.co/u/anjilinga)\
**Post date:** [January 10, 2020, 3:31pm UTC](https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624/1 "2020-01-10T15:31:36Z")

</div>

when i tried to filter the documents from elastic search in canvas metric element giving an unexpected error. can some one please help here

```auto
{
"bool": {
 
		"filter": {
"term": {
"field1": "130402"
 }}
 
			 }
  }

```

---

<div class="post-metadata">

**Author:** ![joshdover](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshdover/32/42020_2.png) [@joshdover](https://discuss.elastic.co/u/joshdover)\
**Post date:** [January 10, 2020, 6:22pm UTC](https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624/2 "2020-01-10T18:22:41Z")

</div>

Hi there Anji!

Could you post your full canvas expression? You can get to it by clicking here:

 ![Screen Shot 2020-01-10 at 11.22.02 AM](https://us1.discourse-cdn.com/elastic/original/3X/7/3/73858e1cd00f5eb9f3713db2ad475396aa0f9eeb.png)

---

<div class="post-metadata">

**Author:** ![anjilinga](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anjilinga/32/86010_2.png) [@anjilinga](https://discuss.elastic.co/u/anjilinga)\
**Post date:** [January 13, 2020, 9:42am UTC](https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624/3 "2020-01-13T09:42:21Z")

</div>

Hi Joshdover,

I have selected as metric and i have added query and the expression editor lokks like below.  
It is showing error symbol in canvas dashboard for the element.

filters  
| esdocs index="dispc\_sip1" fields=""  
query="{ "bool": { "filter": { "term": { "column19": "130402" }} } }"  
| math "unique(region)"  
| metric "With out retry" metricFormat="0,0.[000]"  
| render

---

<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:** [February 10, 2020, 9:42am UTC](https://discuss.elastic.co/t/lucene-query-is-giving-error-in-canvas-metric/214624/4 "2020-02-10T09:42:22Z")

</div>

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