Reports on time ticket moved to other status

[Vera Valshonok]

Hi!

Is there a way to track and create reports on  when exactly (what time date) ticket moved to a different status and t o which one? Looking for a free option, maybe with the help of gadgets, but interested to hear about any options.

Thanks

[Adriana Valentina Hernández Moreno]

Hi Vera, I hope you are doing great!

Jira Cloud has the native post function 'Update Issue Custom Field'; you can add this post function on each of the transitions you want to track.

The post function 'Update Issue Custom Field' will store the exact day and time the transition happened in a date-type custom field when using the %%CURRENT_DATETIME%% value.

--

--

--

Once you set the post functions, only new issues from that point will store this data in the designated customfields. You can then use these custom fields for filters, gadgets, reports, etc. 

For example, you can use the Time Since Chart (Jira native gadget) based on these customfields that store the transition date.

With this option, it is not mandatory to show the customfields in the issue, but if necessary, you can add them.

If you don't want users to edit this field, you can use a different screen for the edit operation that does not contain these customfields.

I hope this information is helpful, 

Best Regards,

Adriana

[Vitalii_Bobak_SaaSJet]

Hi @Vera Valshonok  👋

Also solution can be Time in Status add-on. Which allows you to view the entire duration of an issue, from the time it was opened until it was closed, with the Time in Status report. 

You can also view the Open Ticket Date/Time and Closure Date/Time with the Status Entrance Date report, which displays the date the issue entered each status. 

You can also book a live demo - we'll show you the application inside out and answer all your questions.

I hope this helps 😊

[Mehmet A _Bloompeak_]

Hi @Vera Valshonok

The raw data you need is available in issue history and you can get it using Jira Rest API. It provides status changes for each issue by returning a json which you need to parse to get status transition time.

If you prefer using a marketplace app, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Status Count And Entry Dates report. Entry date(see In Development, Ready for Testing, In Testing, In Development columns.) is status transition date and status count(see #In Development, #Ready for Testing, #In Testing, #In Development columns) is how many times an issue is entered to this status.

App Features:

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. 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.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

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

f you have any questions, feel free to schedule a call with us.

Hope it helps.

[Gizem Gökçe _OBSS_]

Hello @Vera Valshonok ,

The required data is available in each issue's history but to get ready-to-go reports the easiest option is to use a 3rd party app. I understand that you are not looking for a paid solution right now but in case you need it these reports are available in Timepiece - Time in Status for Jira , the oldest and leading Time in Status app in Atlassian Marketplace, which is built by my team at OBSS. 

You can use the date-based reports to see the transition dates from/to a status. In the screenshot below you can see the transition dates of the issues to each status. I think this report will be spot on for your needs.

Let me know if you’d like help setting up this report or need more information! If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem