Extract transition date when status changed from To do ==> In Progress

[Puneet Malik]

Is it possible to extract the transition date to a particular status and then use it for checking that how long the issue is in that status ?

[Emre Toptancı _OBSS_]

Hello @Puneet_Malik ,

Jira keeps status transitions in its issue history but does not provide this information (or status durations) as a report. 

You have a few options but before getting to those, I need to point two things here: First, an issue might visit the same status more than once so those dates will be different. Based on your workflow you might need to use the first or the last date. Second, for some cases using the status entry date makes sense, for other cases using status exit date makes more sense.

Now, possible solutions:

As a first option, you can create custom fields for each status date that you are interested in and use one of the post functions (provided by various apps) to copy the current date to appropriate date field during each transition. This will get you the dates but you need to implement this in every transition of every workflow and actually it is hard to maintain.

Second, if you are interested in a ready built solution, our team at OBSS built Time in Status app exactly for this need. It is available for Jira Server, Cloud and Data Center.

The app contains 4 different date reports that show first/last dates of entry/exit for all statuses.

Time in Status also gives you reports that show how much time each issue spent on each status or assigned to each assignee. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype). You can also combine statuses into consolidated columns to see metrics like Cycle Time or Lead Time.

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.)
• Define your custom calendars for more accurate duration reporting. (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.)
• Export your data as XLS, XLSX or CSV.
• Access data via REST API.
• See Time in Status data and charts for each issue as a tab on issue view screen.

https://marketplace.atlassian.com/1211756

EmreT

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

Hi Puneet,

Enhancer plugin satisfies this requirement easily. Status Timer Field measures how much time an issue spends on a particular status and gives you drill-down information that which assignee spends how much time in that particular status. Enhancer is robust, easy to use, and has many useful features.

https://marketplace.atlassian.com/apps/5139/enhancer-plugin-for-jira?hosting=server&tab=overview

 

As you can see you can also use calendars and different calculation methods for the Status Timer. Moreover, the Status Timer custom field can be added to Jira reports for further analysis.

Let me know if you need further information. I'm one of the folks in Snapbytes.

Regards,

Gökçe

[Mariana_Pryshliak_SaaSJet]

Hello @Puneet_Malik .

You can try both Issue History and Time in Status for Jira Cloud. 

Issue History shows all issue changes, including the time when a ticket has moved from one status to another and who has performed this task.

Time in Status for Jira Cloud shows how much time each task has spent in a specific status and date of first entrance to each status.

I hope this information will be helpful to you.

[Mehmet A _Bloompeak_]

Hi @Puneet_Malik , 

You can use Status Time app for the exact need. It displays time spent on each status based on a calendar(7/24 or working hours).