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

[Nella Juma]

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.

[Hamza Chundrigar]

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

[Nic Brough -Adaptavist-]

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.