# Canvas - Preview shows the correct value but metric shows 0 **URL:** \ **Category:** Kibana\ **Created:** [May 11, 2020, 12:43pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010 "2020-05-11T12:43:21Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jas\_l](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jas_l/32/68066_2.png) [@jas\_l](https://discuss.elastic.co/u/jas_l)\ **Post date:** [May 11, 2020, 12:43pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/1 "2020-05-11T12:43:21Z")
I am on Elastic Cloud and building a metric on canvas that the Preview shows the right values but over on metric, when using - `SELECT COUNT(*) as Series_Title FROM "my_dataset" WHERE "metadataDocument_title" = 'Jack'` Preview will show the right number but when I set the Metric to display the Value of "Series\_Title" it shows 0. I have tried brand new canvas and ensure no filters, time filter or any other exist. Thoughts? Thanks ---
**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:** [May 11, 2020, 6:27pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/2 "2020-05-11T18:27:22Z")
Hi @jas_l Could you share the entire expression you are using for your metric element to help debug? (Select the element and click on _Expression Editor_ in the bottom right) ---
**Author:** ![jas\_l](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jas_l/32/68066_2.png) [@jas\_l](https://discuss.elastic.co/u/jas_l)\ **Post date:** [May 11, 2020, 7:49pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/3 "2020-05-11T19:49:03Z")
Hi @corey.robertson Here is what I have: `filters | essql query="SELECT COUNT(*) as Series_Title FROM \"demo_1*\" WHERE \"metadataDocument.asset_status\" = 'In-Market'" | math "Series_Title" | metric "value" metricFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=96 align="center" color="#FFFFFF" weight="normal" underline=false italic=false} labelFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=14 align="center" color="#FFFFFF" weight="normal" underline=false italic=false} metricFormat="0,0.[000]" | render containerStyle={containerStyle}` ---
**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:** [May 11, 2020, 8:50pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/4 "2020-05-11T20:50:09Z")
Hmm, strange. I know you said you've got all the filters removed, but I always like to step through my expressions one step at a time to help understand where I might be making a mistake. If you change the expression to just ```auto essql query="SELECT COUNT(*) as Series_Title FROM \"demo_1*\" WHERE \"metadataDocument.asset_status\" = 'In-Market'" ``` does it show the query results that match preview? From there you can start adding in each additional step of the expression. like adding on the `| math "Series_Title"` etc. Let me know if that helps. ---
**Author:** ![jas\_l](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jas_l/32/68066_2.png) [@jas\_l](https://discuss.elastic.co/u/jas_l)\ **Post date:** [May 12, 2020, 1:21pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/5 "2020-05-12T13:21:43Z")
@corey.robertson Ah yes that worked. If I build the expression manually it worked. That gets me through. I think it might be although no filters, it was likely the |filters tag that was somehow overriding the result. Thanks for your help ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 9, 2020, 1:21pm UTC](https://discuss.elastic.co/t/canvas-preview-shows-the-correct-value-but-metric-shows-0/232010/6 "2020-06-09T13:21:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.