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?
10 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,
Can I use this feature to exclude tickets containing 0 public comments on my data?
Hi Ben L,
It would be better to create a Standard calculated attribute that identifies tickets with 0 public comments and use that attribute to filter your query.
Hi Ben,
If you're using the metric COUNT(Public Comments) sliced by ticket ID, you could go to result manipulation>>metric filter and exclude any 0 values for this metric as this article covers.
If this isn't quite what you're looking for, can you clarify what metrics and attributes you're using so we can take another look?
Best,
Hey Taylor,
This doesn't seem to work if the values are _all_ 0. In my case, I want to create a table of our Reopens by agent and ID... but I cannot see a way to ensure the table only lists tickets that have been reopened (1 or more).
Hi Timothy,
Thanks for reaching out to us regarding this. I'll be glad to assist you.
You can go to Result Manipulation > Metric Filter and drag the bar to the left to not show 0 results. This would set a floor or ceiling for your results. For more information regarding this, you may check this article: https://support.zendesk.com/hc/en-us/articles/360022184654-Selecting-the-metric-result-range
Hope this helps you out! Feel free to let us know if you need any further help.
Cheers!
Marco M. | Zendesk Support | support@zendesk.com
Hey Marco,
If the results are 0 and 0, you are unable to slide the bar to greater than 0. I want a table that only shows results greater than 0 if there are any. Otherwise, you see _all_ results.
Hi Timothy,
Thanks for getting back to us. I get your point, and just to clarify you want this report to be blank at the moment since all results are 0, correct? If that's the case, there would be no way to do it with how metric filter is set up right now, and you'll only be able to do this once you actually have data to be shown by the report. Meaning once there are results that are greater than 0. It does look that this may be important for your use case, which is why I would suggest also posting this as a feedback or feature request: https://support.zendesk.com/hc/en-us/community/topics/360001200913--Feedback-on-Explore-
Hope this helps clarify it.
Regards,
Marco M. | Zendesk Support | support@zendesk.com
Please sign in to leave a comment.