How do I see which developer has the most REOPENED JIRAs?

Question

I want to query JIRA to see the assignees with the most re-opened JIRAs. The objective is to identify developers who may need additional training.

I would prefer to see this as a PERCENTAGE rather than a RAW number. For example, consider the case where Joe has resolved 100 JIRAs and had 20 get re-opened. Then there's Bill, who resolved only 30 JIRAs, but 15 them get re-opened. In this example, Joe has more re-opened JIRAs, but Bill is the one who needs more training. Joe has a rate of 20% re-opened, where Bill has 50%. It might be even better if I could limit this by date; for example looking at only the last 6 months of data.

One consideration is that a single JIRA may have multiple assignees overtime. I need to identify the single assignee who changed the status from In-progress to Resolved.

Thanks!

Tuncay Senturk _Snapbytes_ · Answer

Enhancer Plugin for JIRA has reopening counter as well as Reopenings issue tab field.

You can find detailed info for "Reopenings" here.

Also you can configure gadget to see charts.

Regards

Tuncay

Jobin Kuruvilla [Adaptavist] · Answer

You can use the JQL,

status was REOPENED

and create a filter. After creating the filter, use the PieChart report to plot the graph by assignee.