Custom Report - How many times a ticket got reopened for each user

[Sayed Kamaloddin Peerzade]

Hi Team,

I am looking for custom report which gives information on issues got reopened how many times against each developers.

I am not finding this in JIRA. Please help me to get the required report.

Thanks,

Sayed

[Rahul_RVS · Accepted solution]

Hi @Sayed Kamaloddin Peerzade 

If you are ok with a marketplace app to get this data you can try out our app.

Time in Status Reports 

The add-on provides the time in each status for the entire lifecycle of the issue and you can filter by issue type as well. You can also combine your statuses to define your lead/cycle/resolution time and also extract the transitions history of the issues. The main features of the app are as below

Also there is a report for the dates when issue transitioned from one status to another.

• Multiple Time in Status Reports. Excel Export available for all status reports.
  
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports
  • Avg Time in status reports
  • Status Change Dates Report
  • Time in Status Per Time Grain
  • Time with Assignee Per Time Grain
• Status grouping
• Save your reports
• CSV Export
• Multiple chart types
• Dashboard Gadget

Disclaimer: I work for RVS, the vendor for this app, and I am one of the developers of the app.

[Sayed Kamaloddin Peerzade]

Hi Rahul,

Thanks for the information. I have installed the app and will come back for any help further.

Thanks,

Sayed

[Yuliia_Borivets_[SaaSJet]]

Hi @Sayed Kamaloddin Peerzade 

If you're comfortable with solutions from the Marketplace, I can suggest 2 developed by my team.

1. Issue History – journal for every past activity, including status changes. Here you can filter by assignee, reporter, project, date range, etc.

2. Time in Status for Jira Cloud will be even better in your case to find out how many times each issue has entered each status. There is a special report for this – Status Count.

Let me know if you have any questions.

[Guy Anela]

Depending on what you mean by "reopened", you could do a JQL search based on the Status change. For example, if reopened means it went from a Done status to a To Do or In Progress Status, then you could use a JQL search similar to this...

Project=ABC AND Status CHANGED FROM (Closed) TO (Backlog, "In Progress", "In Test")

Keep in mind that the above example assumes the Workflow only contains Backlog, In Progress, In Test, and Closed Statuses (where ANY status can go to ANY status). It would need to be tweaked for your specific Workflow.

Once you have the Filter defined, you can export the results into Excel to Group/Graph the data, OR you can simply apply the filter to an Issue Statistics Dashboard Gadget and set the Statistic Type to "Assignee" (or whatever field you're using to track the Developer). This should give you a count of how many tickets were reopened for each developer.

Anyhow, just wanted to include this potential "out-of-the-box" solution. :) I hope this helps. Cheers!

[Steve Farrand]

Ace.  
No 'try my app' needed.

[Mehmet A _Bloompeak_]

Hi @Sayed Kamaloddin Peerzade,

There is a good solution for your request - Status Time Reports app developed by our team.

By default, it provides reports on how much time passed in each status. But it also shows status entry counts (in your case how many times an issue has entered "Reopened" status). You can also export the report as CSV and open it in Excel.

Here is the online demo link, you can see it in action and try without installing the app. Hope it helps.

[Sayed Kamaloddin Peerzade]

Hi Support Team,

Thanks for the valuable input. I have requested for application but it says "App name not available"

Please help me to get the application access to it.

Thanks,

Sayed

[Mehmet A _Bloompeak_]

Hi @Sayed Kamaloddin Peerzade ,

Your Jira admin can install the app over the Atlassian Marketplace using the try button from the below page.

https://marketplace.atlassian.com/apps/1221826/status-time-reports?tab=overview&hosting=cloud

[Gerda Grantiņa]

Hi @Sayed Kamaloddin Peerzade
Also, the eazyBI app provides options to count how many times issues have been re-opened or how many times. 
One of those examples you can find in eazyBI Community posts: https://community.eazybi.com/t/how-to-count-issues-that-had-ever-been-reopened/3466/2

If you have any questions, feel free to contact us: support@eazyBI.com

Best,
Gerda

[Hari Krishna Manepalli]

Can we install this tool for free of cost or is it chargeable. It Looks like there is a charge on this tool once free trial is over.

[Gerda Grantiņa]

Hi @Hari Krishna Manepalli ,
Yes, the eazyBI app is a paid app, and after the free trial period ends there is a charge on it: 
You can see prices here (you can select hosting you are interested in - Cloud, Server or Data Center): https://marketplace.atlassian.com/apps/1211051/eazybi-reports-and-charts-for-jira?hosting=cloud&tab=pricing

best,
Gerda

[Hari Krishna Manepalli]

Thank you for the update.

I want to see just How many times the bug got Reopened. Is there any other solution other than paid tool.

[Emre Toptancı _OBSS_]

Hello @Sayed Kamaloddin Peerzade ,

I have the solution for you. Our team at OBSS built Timepiece - Time in Status for Jirafor this exact need. It is available for Jira Server, Cloud, and Data Center. 

Time in Status has many report types but particularly Status Count and Transition Count reports will help you. These reports show how many times each Status and each transition was used.

 

For all numeric report types, you can calculate averages and sums of report values grouped by the issue fields you select. For example, total re-open count per issue type or average reopen count per week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) is particularly useful here since it allows you to compare different time periods or see the trend.

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

And the app has a REST API so you can get the reports from Jira UI or via REST.

  

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets

Timepiece - Time in Status for Jira

EmreT

[Mohamed Benziane]

Hi,

You can try to use the API and look at the history of your tickets to find which issue went to specific status and the author.

You can also look at the marketplace to find a suitable plugin.