Question
My query is displaying zero values for some dates. How can I exclude zero values?
Answer
In the query builder, select result manipulation () > Metric filter
Using the slider, define the range of values to include and exclude. Move the slider to 1 or higher to exclude zero values:
Note: If you need to specify decimal places in your range of values, you can click on the numbers that appear beneath the slider and type in your values manually.
If you need to exclude blank or empty/null values (not zero values), see this article: How do I exclude blank values from my query?
3 Comments
We should be able to use >=1 that we dont have to set max statically
Hi there,
I have the 'Remove blank values' unchecked in Metric filter in Results manupulation , however, the week with zero value still not shown on the chart(week 34 is missing on the screenshot below) Can someone please help?
Hi Vladmimir,
You'll find this article helpful in achieving this: How can I include 0 values in reports?
Hope this helps!
Best,
Please sign in to leave a comment.