How do I exclude blank values from my report?



Edited Apr 11, 2025


0

7

7 comments

      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


      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


      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


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

      And nothing changes in my results.

      0


      Hi Chris Bulin, That's perfect, thank you for your help ! 

      regards

      0


      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


      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


      Sign in to leave a comment.