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 16616068608, 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.