How to filter by a blank value in Charts and Reports for Jira ServiceDesk?

[Amanda McGivern]

I recently installed Charts and Reports for Jira ServiceDesk and I was wondering if anyone knew if it's possible to filter my KPI by a field having a blank value? 

My use case is that we have a field called "Pending Reason" which gives us some more information about the "Pending" status. I would like to include issues that are either waiting on the customer or waiting on nothing.

I cannot figure out how to do this using the UI. It appears that when I add a new filter, there is no option for a blank value. Is what I'm trying to accomplish possible?

[Fahad Siddiqui]

Try the below query

"status = Open or status = "waiting on the customer" AND project = "XYZ" 

[Amanda McGivern]

Unfortunately, I don't think it's possible to use JQL with this extension. This is what the filter UI looks like: 

[Fahad Siddiqui]

Due you have any tab advance or basic?

[Amanda McGivern]

No, I just contacted their support team and this option is only available for certain fields like resolution.

Thanks for your help

[Fahad Siddiqui]

In future if you want to work on Charts and Reports using dashboard, try using add-on "Rich filters".