How do I exclude zero values from my Explore query?

Return to top
Have more questions? Submit a request

6 Comments

  • Jiri Kanicky

    We should be able to use >=1 that we dont have to set max statically

    0
  • Vladimir Petrushenka

    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? 

     

    1
  • Taylor Bowser
    Zendesk Customer Advocate

    Hi Vladmimir, 


    You'll find this article helpful in achieving this: How can I include 0 values in reports? 

     

    Hope this helps!

    Best, 

    0
  • Ben L

    Can I use this feature to exclude tickets containing 0 public comments on my data?

    0
  • Hannah Meier
    Zendesk team member

    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.

    0
  • Taylor Bowser
    Zendesk Customer Advocate

    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, 

    0

Please sign in to leave a comment.

Powered by Zendesk