Recent searches


No recent searches

How do I exclude blank values from my report?



Edited Jan 24, 2024


0

7

7 comments

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


image avatar

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


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

regards

0


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

And nothing changes in my results.

0


image avatar

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


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


image avatar

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.