How do I exclude blank values from my report?

Return to top

7 Comments

  • Pagot Alexandre

    Hi 

    I'm also interested to find out how i can exclude some value from my querry. 

    In my case I created a querry to show the tickets in the backlog history per week and per year. For 2020 it's all good, but for 2021 for each futur week I have blank values wich are displayed. I can't find a way to not diplayed them. 

    You can find a screeshot of my querry. 

    To be more precise, I would like to see only the data from past week. 

    Any Help our advices will be apreciated ! 

    Regards

    0
  • Chris Bulin
    Community Moderator

    Hello Pagot Alexandre. You can use the Configuration menu to do this. Go to Chart, and then click on the option to not replace missing content with a 0 value. Hope that helps!

    0
  • Pagot Alexandre

    Hi @..., That's perfect, thank you for your help ! 

    regards

    0
  • Giannis Nanos

    When I try to filter out blank results using Metrics I get this message:

    And nothing changes in my results.

    0
  • Gab Guinto
    Zendesk Customer Care
    Hi Ioannis,
     
    Looks like we need to investigate further on this one. I'll be creating a private ticket on your behalf so that we can continue our conversation from there.
    0
  • Tom Boland

    Hi, I'm having a similar issue as Ioannis above, my queries are returning values that are unlabeled and I'm unsure how to remove them. Attaching screenshots.

    0
  • Gab Guinto
    Zendesk Customer Care
    Hi Tom,
     
    It looks like those are tickets with null values for the attribute/custom field. If you want to hide those from your chart, then you can filter the attribute Inquiry Type and Data Inquiry Type and exclude NULL.
    0

Please sign in to leave a comment.

Powered by Zendesk