Tracking the number of transitions of an issue to a specific status

[Иван Беляков]

Hello.

Not sure if can be done in Jira itself or in Structure.

So I would like to to track how many times an issue has transitioned to a certain status, for example "To do". By this, I want to see bugs that have been returning to development more than x times - that would mean that there is some problem with this bug.

Is there any way to set up Structure formula to track how many times an issue was in certain status?

[Yulia Barbash _ALM Works_]

Hello @Иван Беляков !

Yulia with ALM Works Here.

I'm happy to announce that we just released Structure 7.4 and among other things, the support for History by the Formula column.

The use-case you provided can be solved by a formula like this:

history.changes.filter($.field = "status" and $.to = "status name").size()

You can find more in our documentation.

Please feel free to try the new version and let me know if you have any questions.

Best regards,
Yulia Barbash
www.almworks.com

[Alexander Bondarev]

Thanks, @Yulia Barbash _ALM Works_ ! 

It works, wonderful!

[Yulia Barbash _ALM Works_]

Hello @Иван Беляков 

Yulia from ALM Works here!

At the moment, the ability to track how many times an issue has transitioned between statuses is not available in Structure.  We do have a task in our backlog related to this. I will reply here when an update is available.

Best regards
Yulia Barbash
www.almworks.com

[Bloompeak Support]

Hi @Иван Беляков ,

It is not possible using the built-in JQL functionalities of Jira. So we developed Status Time app for this exact need. It provides reports on how much time passed in each status, 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 entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

[Иван Беляков]

Thank you.

I've tried demo and when I filtered issues by "Bug" type it didn't show any issues for me. Don't know what's the problem. Any other issue type filters fine.

[Bloompeak Support]

@Иван Беляков,

Can you email us over support@bloompeak.io, so that we can schedule an online meeting in which we can have a look at your case?

[Иван Беляков]

I've recorded a short video
https://drive.google.com/file/d/1UzlS6LN3ygmjFO1BdSb17ity8IUHsaBB/view?usp=sharing

[Bloompeak Support]

Thanks for the detailed explanation of the problem @Иван Беляков .

I was able to reproduce the case after I switched my language to Russia. It was happening for the issue types with Russian characters. We just developed a new version which handles Russian characters as well. Could you please check it?

[Иван Беляков]

Hello. Now it works in demo, doesn't work in the app though.

[Bloompeak Support]

We applied the fix for the cloud. Server/Data Center version is on the go, will be done within today.

[Иван Беляков]

Cool, thanks

[Mehmet]

Server/Data Center version is now available.

[mmhassan]

I have a workaround without using any third-party app. 

1. Create a numeric field name as iteration and put the default value to 0.
2. Create an automation rule which triggers on issue transition from one status to a particular status and edit the field iteration via smart value {{issue.iteration.plus(1)}}

[Jack Brickey]

You would need some form of automation or scripting and a custom field that could be incremented each time it enters that status. There are a number of add-ons that will work with post functions on transitions which is another approach.

[Ilze Leite-Apine]

Hi @Иван Беляков, 

You may consider using some Jira apps, mentioned above, or check out eazyBI for Jira app if you are into want to dig deeper in reporting.

Analyzing issue change history, including transition changes, is out-of-the-box in eazyBI.

You may explore the eazyBI demo report that illustrates that: Issue status changes by users 

You can see transition authors and how many times they did transitions to statuses and how many issues were transited. From any cell in the report, you can retrieve the list of issues composing this value.

Please contact support@eazybi.com if you have any further questions!

Ilze , eazyBI Customer Support Consultant

[Emre Toptancı _OBSS_]

Hello @Иван Беляков

The data you need is available in each issue's history but Jira does not have an out-of-the-box report to show this. You will need to use a marketplace app.

Our team at OBSS built Time in Status app for this exact need and it is available for Jira Server, Cloud, and Data Center.

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee but it also has reports showing how many times each status and each transition was used. It is perfect to count reopens.

   

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.

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.

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

[Иван Беляков]

Hello.

I haven't found a way to filter list by issue type. Is there such possibility?

[Shaili_RVS_Support]

Hi @Иван Беляков 

If you would be interested in a readymade solution, you can look at our plugin to get this data. 

Agile Tools : Epic Tree & Time in Status 

The Time in Status module of the app provide the status transition count report along with other important features, as below to track time and manage issue hierarchies

1) Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features

2) Timesheet :- View/Enter your time spent for multiple days

3) Links Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels), based on your Issue Links parent child relationship.

4) Epic Hierarchy :- View/Manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask

5) Time in Status :- More than 7 types of Time in Status reports to track your issues.

[Иван Беляков]

Thank you. Can't filter by issue type though (maybe problem related to Russian language as well) and I didn't understand how to remove the transitions which I don't need (all of them are shown and there are too many)

[Shaili_RVS_Support]

Hi @Иван Беляков 

Thanks for your reply. Yes there is an issue in the app related to Russian language. We will be fixing it soon in our next release. Regarding the second query, you can add/remove statuses from the results by using the "Statuses" filter.

Please do let me know for any further queries.

[Rahul_RVS_Support]

Hi @Иван Беляков 

The issue related the Russian language support has been fixed now.

Request you to please download the latest version and try it out.

Pls do reach reach out to us for any queries.

Thanks

Rahul