# Canvas data show is different

**URL:** <https://discuss.elastic.co/t/canvas-data-show-is-different/259627>\
**Category:** Kibana\
**Created:** [December 25, 2020, 10:09am UTC](https://discuss.elastic.co/t/canvas-data-show-is-different/259627 "2020-12-25T10:09:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![salma\_widiarti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/salma_widiarti/32/78306_2.png) [@salma\_widiarti](https://discuss.elastic.co/u/salma_widiarti)\
**Post date:** [December 25, 2020, 10:09am UTC](https://discuss.elastic.co/t/canvas-data-show-is-different/259627/1 "2020-12-25T10:09:00Z")

</div>

Hi All,  
I want to show data STAMP/day

And this is my ES Query

```auto
SELECT count(labels.status::varchar) as Stamp FROM "apm-*" WHERE labels.status = 'STAMP' AND labels.tanggal = 'DATE(NOW())'

```

But why the result is 0, even though total stamp today is 12.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/c/eca97e0a1d7854df6f0447519df11bf7968af2e8.png)

Anyone can help me?

---

<div class="post-metadata">

**Author:** ![corey.robertson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/corey.robertson/32/54611_2.png) [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)\
**Post date:** [December 28, 2020, 2:39pm UTC](https://discuss.elastic.co/t/canvas-data-show-is-different/259627/2 "2020-12-28T14:39:16Z")

</div>

Hi @salma_widiarti

Typically in Canvas this is caused by an additional filter being applied in your expression that you weren't expecting.

If you look at the expression for this metric (select the metric, select "Expression Editor" in the bottom right) you should see your expression starts with `filters | essql ....`. If you remove the `filters |` part from the beginning, no additional filters will be applied and it should only apply whatever filters are in your actual SQL query.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![salma\_widiarti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/salma_widiarti/32/78306_2.png) [@salma\_widiarti](https://discuss.elastic.co/u/salma_widiarti)\
**Post date:** [December 29, 2020, 2:12pm UTC](https://discuss.elastic.co/t/canvas-data-show-is-different/259627/3 "2020-12-29T14:12:19Z")

</div>

HI @corey.robertson

Thanks for your advice, it worked for me.

But why, when i change query like this

```auto
SELECT count(labels.status::varchar) as Stamp FROM "apm-*" WHERE labels.status = 'STAMP' AND labels.tanggal = 'YEAR()'

```

And i was remove the `filters |` the result still 0?

---

<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:** [January 26, 2021, 2:12pm UTC](https://discuss.elastic.co/t/canvas-data-show-is-different/259627/4 "2021-01-26T14:12:38Z")

</div>

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