How can i easy get the calculated amount of times, that issues was reopened.

[Sergii Delimarskyi]

Hello!

For the report issues i neede to provide the amount of times each task was reopened and overal amount.

I did perform a search. And it is not easy to find a solution which could be used as dashboard

Where i will wright something like this:

project  = x and status was returned before startOfTheDay()
Item ................. Reopened count

Item. ................ 1

Item ................. 3

Item ................. 4

Item ................. 1

Item ................. 2

             Sum: 11

I use JQL and dash boards a lot, but dont find an solution.  

Thanks for your help!

[Chris Buzon]

You could do this with Jira automation, though it will take a bit of work. It will not allow you to look for historical information, however. It will only record the number from the time the rule is created, onwards.

1) Create a custom field, name it something like Issue Reopen Count
2) In an automation rule, whenever a ticket is transitioned from the Closed state(s) back to an open one(s), have your automation rule edit the issue and add + 1 to that custom field.

You can then create a report for issues that have a Issue Reopen Count that is not EMPTY. The Issue Statistics and Filter Results widgets would work great for that.

[Chris Buzon]

https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/

You'll need to use these smart values and identify the customfieldID in order to access the information in your new custom field, and apply some math to it.

[Emre Toptancı _OBSS_]

Hello @Sergii Delimarskyi and @Joe Pitt ,

For a ready built solution that offers great flexibility and details, 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 contains reports that show how many times each status and each transition was used in an issue's workflow. Additionally Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee as well as entry/exit dates for all statuses. You can calculate averages and sums of those durations and counts grouped by issue fields you select. (For example see the total InProgress time per Epic, or average number of InProgress transitions per issuetype). You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time or Lead Time.

     

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.

The app has Custom calendar support which means you can get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

Finally, the app has History Trim feature. This feature allows you to report on a subsection of issue histories instead of the whole history. Very useful when you want to focus on changes made during sprint or project phase.

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 issuetype.)
• Export your data as XLS, XLSX or CSV.
• Access data via REST API.
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets (released for cloud, server&DC gadget coming soon)

https://marketplace.atlassian.com/1211756

EmreT

[Bloompeak Support]

Hi @fobrutsky ,

You can try Status Time app developed by our team at Bloompeak. It provides reports on how much time spent on each status as well as status entry dates and status count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status count, average/sum reports(eg. average in progress time per project).

Here is the online demo link, you can see it in action and try.

Hope it helps.

[Joe Pitt]

@Gökçe Gürsel {Appfire} is this available in cloud? With the ending of new server licenses next year and support in 2024 anyone starting to depend on a solution not cloud supported may have a big problem in the future. 

[Gökçe Gürsel {Appfire}]

Hi @Joe Pitt ,

We're planning to release Enhancer Plugin for Jira Cloud version in the first half of 2021. 

-Gökçe

[Gökçe Gürsel {Appfire}]

Hi @Sergii Delimarskyi ,

You can try the Enhancer Plugin for Jira for this.

It has a custom field called "Reopened" Status Counter Custom Field that does exactly the name suggests, shows how many times the issue is reopened.

It also has other cool features like Time in Status custom field (shows the amount of time an issue spends on a particular issue with a piece of drill-down information by assignee), Time between custom field ( shows time spent between two statuses/events), workflow validators, conditions, post functions and so much more!

Please let me know if you have further questions.

Cheers,

Gökçe

Please note that I'm one of the members of the Snapbytes team.

[Sergii Delimarskyi]

Hello! Thanks!

Does this plug in is able to work with dashboard reports like: 
Two Dimentional Filter Statistic. 
Pivot Table
Pie Chart

Or gime please advice how to get this calculated in report by certain person project or team.

What is the comfort way to get agregated calculated report?
I an good with JQL so lets asume we have a good filter of tasks which was reopened during period.

How to get calculation BY (member, team, project?)

[Sergii Delimarskyi]

We have stand alone JIRA.

So it seems we are able to get benefit of this.

once again does this solution allow to receive a historical view?

[Gökçe Gürsel {Appfire}]

Hi @Sergii Delimarskyi ,

Yes, Enhancer Plugin for Jira allows a historical view. All you need to do is to install the plugin, define the custom field of your choice, and then you need to perform a reindex. After that, you're done. Existing issues will have Reopened Count data available for them. You can use this custom field in JQL and add it as a column to the issue navigator.

As for the gadget, I don't think that this custom field is available to use in all out-of-the-box gadgets but don't worry, Enhancer Plugin for Jira comes with its own gadgets to visualize the data.

"Reopened" Status Counter custom field can be used in Status Counter Gadget like this.

As for the grouping by the user, Enhancer has another gadget called user performance gadget by which you can see a user's performance - reopenings, resolutions etc. AND you can limit this gadget to a certain project by a JQL. This should give you a good indication of reopenings by the user per project (or any other JQL) and the overall performance of your team. Also, these numbers in the gadget are interactive, when you click on them, it'll take you to the relevant issues in the issue navigator.

Enhancer Plugin for Jira has a lot of other features as well. I believe it will satisfy your requirements nicely.

Let me know if you have further questions.

-Gökçe