Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How do I write a JIRA query to count how many tickets in the backlog have not been sized?

Nella Juma
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 7, 2022

I would like to create a dashboard to track how many tickets have not been sized in the backlog and have not been sized in the current sprint. I am only tracking tickets and storys and once in the dashboard was asked to create a custom count query for the "story size" being empty.

2 answers

0 votes
Hamza Chundrigar
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 Leaders.
November 7, 2022

Hi @Nella Juma 

The JQL to find issues that do not have been sized (i.e. Story Points field has not been fulfilled) within a project — you could use the following query:

project = MP AND "Story Points[Number]" = Null

Replace MP with your Project Key


If you would like to query for multiple projects at once with the same criteria then you can use:

project in (A, B, C) AND "Story Points[Number]" = Null

You can then use these JQLs in your dashboard gadgets such as the Filter Results gadget ( that displays the results of an issue filter) or you could use the Issue Statistics gadget (which would display the collection of issues returned from a filter, broken down by a field).

 

Cheers,

Hamza

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 7, 2022

Welcome to the Atlassian Community!

Start with a look at the filter for the board (if it's not a Software board, it will probably be just "Project = X")

Take a copy of it, and add two new clauses 

and "story size" is empty and status not in (closed, done, ended)

You now have a filter that will find unsized issues in your backlog, including any in open sprints (active or future).

You can now use that filter in any dashboard gadget to help drill down into or report upon the list.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events