Creating new labels in JIRA - How to measure time beetwen every worklfow step

[Kacper P]

Hello!
I am a user of your product - Jira (Software 7.1.10) and I need to find some features that would help me in my administrative work. I need to create some labels in my JIRA.
As a community, we need to count our key performance indicators (KPIs). That's why I'm writing to you. I am looking for a good solution to count the time between the statuses of our issues. We are creating a custom workflow for several projects - we have added some new statistics such as "NEW", "NEED INFO", "READY FOR WORK", etc.
Now I need to get information about the changed time for the selected status. In the "Search for issues" tab, I have columns such as "Created", "Resolved" and "Closed", and now I need to have the same type of columns (showing me the date of change for that one status), but named as "NEEDED INFORMATION"; "READY FOR WORK", etc.
Can you tell me how I can make these changes?

[Valeriia_Havrylenko_SaaSJet]

Hi @Kacper P 👋 
Welcome to the community!

And thank @Sudarsana G for recommending Time in Status!

But for your needs I would recommend trying out our another add-on Time Between Statuses. Add-on help you track and report on key performance indicators (KPIs) by measure the time issues spend in each status during their lifecycle

You can also set up highlights of values that exceed the permissible level, and in this case, you can receive issue and email notifications.

 Benefits:

• Identify Bottlenecks: Quickly see where issues are getting stuck in your workflow.
• Optimize Processes: Use data to streamline processes and improve efficiency.
• Enhanced Reporting: Gain deeper insights into your team's performance and workflow effectiveness.
• Improve Accountability: Make data-driven decisions to hold teams accountable and drive continuous improvement.
  
  

Add-on has 30-days trial version, free up to the 10 users and developed by my SaaSJet team.

I hope this helps 😊

[Sudarsana G]

You will have to Use A plugin called Time in Status Or there is an article about it

[Amay Purohit_RVS]

Hi @Kacper P ,

Welcome to the community !!

You can use Jira Rest API's to pull this data and build your own custom solution, or also write some automation rules to populate your custom columns. Another alternative, would be to use a ready made solution from the marketplace. if you are open to try out one, take a look at

Time in Status Reports 

The example below shows the "Cycle Time" column which is nothing but a Status group created by the app by combining few statuses. The app will then add up the time in status in each of the statuses and show in the column "cycle time". Similarly you can create your owne custom status group like READY FOR WORK etc

More app details here

The app is free for 10 users. Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Gizem Gökçe (OBSS)]

Hello @Kacper P ,

Welcome to the community!

In order to measure the duration between statuses or the status durations I suggest you use a 3rd party app. For this purpose I can recommend Timepiece (formerly Time in Status) app, the oldest and leading Time in Status app in Atlassian Marketplace, which is built by my team at OBSS. There are many applications on the Atlassian marketplace that can give you the reports I am going to mention below, but you have to download more than one application to get all of them. Thanks to Timepiece, you can get all the reports from a single app!

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee. 

Timepiece offers two report types for your case:

The first one is Status Duration report (please see the screenshot above) which shows how much time each issue spent on each status. You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

As an alternative approach, Timepiece also has Duration Between Statuses report type which shows the duration between two specific statuses. This report type also allows the user to exclude the times for "pause" statuses.

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

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. And the app has a REST API so you can get the reports from Jira UI or via REST. Also you can export the reports in to various formats and other reporting tools (like easyBI, powerBI etc.) easily. 

Visit Time in Status to explore how our JIRA add-on can revolutionize your metrics measurement process. Enjoy a 30-day free trial to experience the full range of features.

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.

Kind Regards,

Gizem

[Mehmet A _Bloompeak_]

Hi @Kacper P

Welcome to the Atlassian Community!

You can try Status Time Reports app developed by our team. This app mainly provides reports and gadgets based on how much time passed in each status. It also has a dynamic status grouping feature so that you can generate various valuable reports as cycle time and lead time, time in status, time in assignee, status entry dates and status counts, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

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

For further details, you can have a look at Cycle Time and Lead Time in Jira: Productivity Measurement with Two Critical Parameters article and Status Time Reports How to Videos.

App Features:

• 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 completely  free solution, you can try the limited version Status Time Reports Free.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

[Stephen_Lugton]

@Kacper P You can do this without needing a plugin:

First create new date (and time if you want) fields for each status you want to track.

Then create an automation that triggers on status change, and use a branching if/else structure to set the appropriate custom field to now()

You can then add  these fields as columns in your search tab

[Deniz Oğuz - The Starware]

Hi,

There can be multiple transition to each status. Depending on your requirements you may want to measure first transition, last transition or total of all transitions. A single date field may not be enough to track. But you may pull this information from issue history if it is accessible from automation. 

[Deniz Oğuz - The Starware]

Hi Kacper,

If you are on Jira DC and open to using a marketplace app, you can use our "Custom Fields++" app. It has "Time in Status" custom field, which can display time spent in each status using different configurations. Since this is a custom field, you can also add it to workflow transition screen or issue navigator as a column. You can add multiple instances of the field to measure different statuses. It is also indexed in the field can be used in JQL queriers like, "time in review" > 1d.