How do I exclude blank values from my query?

Return to top
Have more questions? Submit a request


  • Tsvetan Marinov

    HI @...,

    In words, it sounds very nice and this is what exactly I need. But for some reason it doesn't works for me:


    But the zero results are still displayed which I don't want to them in my chart:


    Does this feature work as expected or I am missing something? Our assistance will be much appreciated.



  • Brett Bowser
    Zendesk Community Team

    Hey Manuel,

    I'm going to create a ticket on your behalf so we can look into this report for you. We will need to assume into your account to see if we can replicate this issue on our end. You'll receive an email shortly stating your ticket has been created.


  • Viorica Pop

    Hi -

    I'm also interested to find out how it can be achieved. The suggested feature in this article is not working. 

    In my case, we have a bar chart where we display new/open/pending tickets for each organization, but for those organizations where there are no tickets, we would like to hide them completely from the chart.



  • Ben Van Iten
    Zendesk Community Team

    Hi Viorica Pop,

    Would you mind sending along a screenshot or explaining what is going wrong with this feature? As much detail as you can provide will be appreciated!



Please sign in to leave a comment.

Powered by Zendesk