How do I exclude blank values from my query?

Return to top
Have more questions? Submit a request

7 Comments

  • 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.

    Regards,

    Tsvetan

    0
  • 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.

    Cheers!

    1
  • 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.

     

    Thanks!

    1
  • 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!

    Thanks!

    0
  • 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 Chris Bulin, That's perfect, thank you for your help ! 

    regards

    0

Please sign in to leave a comment.

Powered by Zendesk