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

Sayed Kamaloddin Peerzade January 24, 2022

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

7 answers

1 accepted

0 votes
Answer accepted
Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 24, 2022

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.

 

StatusCount.PNG

Sayed Kamaloddin Peerzade February 21, 2022

Hi Rahul,

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

Thanks,

Sayed

Like Rahul_RVS_Support likes this
3 votes
Yuliia_Borivets__SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 24, 2022

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.

how to get issue history.png

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.

2022-01-24_16-17-24.png

Let me know if you have any questions.

1 vote
Guy Anela September 7, 2023

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 May 14, 2024

Ace.  
No 'try my app' needed.

Like Guy Anela likes this
1 vote
Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 24, 2022

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 January 25, 2022

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

Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 25, 2022

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

0 votes
Gerda Grantiņa
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 25, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 17, 2022

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 17, 2022

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 17, 2022

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.

0 votes
Emre Toptancı _OBSS_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 24, 2022

Hello @Sayed Kamaloddin Peerzade ,

I have the solution for you. Our team at OBSS built Time in Status app for 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.

TransitionCount.png  StatusCount.png

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.

tisCloud_StatusDuration_LeadTime_Average_TimeGrouped.png

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.

Gadget_AverageStatusDurationByComponent.png  tisCloud_StatusDuration_LeadTime_Chart.png

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

https://marketplace.atlassian.com/apps/1211756/

EmreT

0 votes
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 24, 2022

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events