How to find Remaining Tickets

[Piyushi Sharma]

I will greatly appreciate if someone could help me with how to get a count of remaining tickets at the end of each month. What JQL should I apply if I use a filter? And, how to show Created vs. resolved Vs. Remaining tickets on a line graph?

[Joseph Chung Yin]

@Piyushi Sharma -

Welcome to the community.  In JQL, if you focus on the "Resolution" field then it will give you all the issues that is not closed -

"project = xxxx and resolution is empty"

In general for Jira/JSM, when an issue's resolution is not populated, then it means the issue is still not completed.  NOTE - when an issue resolution is not populated, the internal representation of the null value on resolution field is "Unresolved".  When an issue moves into the terminal WF status (i.e. Done or Closed), the resolution field will be populated by default via the WF.

You can just use the "Created vs Resolved" gadget in the dashboard to see the data in a line graph.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Evgenii]

Hi, @Piyushi Sharma 

Created issues:

project = ZZZ AND created >= startOfMonth()

Resolved:

project = ZZZ AND created >= startOfMonth() AND resolution IS NOT EMPTY

Not resolved

project = ZZZ AND created >= startOfMonth() AND resolution IS EMPTY