Created VS Resolved report

[Ahmed Elgizouli]

I want to create a report to show me the number of created tickets on a certain date and number of resolved tickets of that date

createdDate=resolvedDate

this syntax is incorrect, anyone advise what is the correct one?

Thanks

[Jack Brickey]

Hi Ahmed, have you considered using the Created vs Resolved gadget on a Dashboard. It does a nice job of this.

[Jack Brickey]

hmmm, maybe you are asking for a report of all issues that were created AND resolved on the same day?

if so you could use a JQL like this...

createdDate >= 2020-05-13 and createdDate <= 2020-05-14 and resolutiondate >= 2020-05-13 and resolutiondate <= 2020-05-14

but you can’t construct a generic JQL. If you want to start tracking this ongoing consider an addon for scripting.

[Ahmed Elgizouli]

Hi Jack,

Thank for your reply,

yes, i am not looking for a specific day i want to a generic report 

anyhow thankx

[Ahmed Elgizouli]

Hi Jack,

how can I get the addon?

[Jack Brickey]

Hi Ahmed, you can go to marketplace.atlassian.com and search for various addons. Consider the ever-present Scriptrunner, Power Scripts, etc. pondering this more, there may be a charting/reporting addon that could give you what you want as well. Really what I think you are looking for here is a ‘time to resolution’ type report and ideally one that allows you to define the threshold, I.e. “show me the percent of created issues resolved within 24h and illustrate this in a report with daily granularity.” Personally I would probably try to do this in PowerBI but there are other options. Maybe EasyBI, unsure as I haven’t used in some time.