Needing JQL query to see number of tickets opened and closed in the same day.

[Aaron Johnson]

I'm having a difficult time finding a way to identify tickets in the past 30 days and identifying which ones were opened and closed during the same calendar day.

Any assistance would be great!

So far I have the below query:

project = "xyz" AND status changed from "waiting for support" to Resolved AND created <= -30d

But the above does not identify the time between status change.

[Jack Brickey · Accepted solution]

note you could simply use the Created vs. Resolved gadget on a dashboard for this. With that said try this JQL...

createdDate >= startOfDay() and resolutiondate <= endOfDay()

save the filter as something like "same day closures" then use that filter in a gadget on a dashboard.

[Aaron Johnson]

Thank you very much.