Forums

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

New vs closed chart possible?

Bud Herz
Contributor
August 13, 2025

Challenge: 
Looking for a way to show number of new issues vs done issues over a rolling 24hrs 

Goal:
Simple method to gauge early risk when counts start going up instead of down.

Sometimes the focus is so tight on getting planned work done, stakeholders lose sight of the growth of new issues (bugs or added stories). Progress may appear to slow when we are opening more issues than we are closing.

Question:
What JQL query might help display status changes for the last 24hrs limited to issues opened (created) vs issues done (closed, etc)?

Is that possible?

 

Currently Using Separately :
NEW ISSUE JQL
project = FS AND issuetype IN (Bug, Story, Task) AND created >= -24h ORDER BY status ASC, Key ASC

DONE ISSUES JQL:
issuetype in (Bug, Story, Task) AND status in ("UAT-DONE", "Closed", "UAT Ready") AND status CHANGED TO ("UAT-DONE", "Closed", "UAT Ready") AFTER -24h ORDER BY status ASC, updated ASC

1 answer

2 votes
Trudy Claspill
Community Champion
August 13, 2025

Hello @Bud Herz 

If you are setting the Resolution field on all of those "done" statuses you could use the Created vs. Resolved dashboard gadget.

https://support.atlassian.com/jira-cloud-administration/docs/use-dashboard-gadgets/

Then you don't need separate filters.

Do you have other "done" statuses that you want to exclude and that are used for the Bug, Story, and Task items types? If not then just use this query:

project = FS AND issuetype IN (Bug, Story, Task) 

And use the Created vs. Resolved dashboard gadget to display a graph of the data.

Suggest an answer

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

Atlassian Community Events