New vs closed chart possible?

Question

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

Bud Herz_4dzuwt · Answer

Hi @Trudy P Claspill

This totally fell off my radar for a while (obviously) heh heh

We run one project with two Sprints across a single board. 
2 week sprints contain To-Do through UAT Ready
Release sprints contain UAT Ready through UAT Done

UAT Ready isn't a DONE resolution so I don't think the built in Created vs Resolved will work.

Am I correct?

Trudy P Claspill · Answer

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.