The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Amanda McGivern
August 28, 2020

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?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Fahad Siddiqui
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 29, 2020

Try the below query

 

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

Amanda McGivern
August 31, 2020

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

Fahad Siddiqui
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 31, 2020

Due you have any tab advance or basic?

Amanda McGivern
August 31, 2020

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

Thanks for your help

Like Fahad Siddiqui likes this
Fahad Siddiqui
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 31, 2020

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

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events