Time from opening to a specific state

[Catalina Martinez S]

Is there any way in which the enable time can be calculated from when an incident is opened until it goes to a specific state?

[Mikael Sandberg · Accepted solution]

Hi @Catalina Martinez S,

Welcome to Atlassian Community!

One option is to use automation to calculate the time. Another option is to look at the Marketplace which has apps that will generate reports on this.

[Catalina Martinez S]

Thanks,

Any ideas how i can calculate it with the automation? 

I don´t see any options for that.

[Mikael Sandberg]

You would need a custom field that displays the calculated time. Then create an automation that is run when the incident is transitioned to the specific status, use the Create variable action to calculate the difference between now() and the created date, then use that variable to set the custom field.

Also check out the Automation Playground, it might have an automation that does similar calculations.

[Catalina Martinez S]

Thanks for your help. 

[Julia Shcherbyna _SaaSJet_]

Hi @Catalina Martinez S 

Seems like you need to calculate the cycle time. Check an article to know more about how to analyze Cycle and Lead Time in the Jira 3 tools to analyze Cycle and Lead Time in the Jira

Check out Time in Status for Jira Cloud developed by my team. You can generate time in status reports with cycle and lead time here.

Write me if you have a question. Hope it is useful for you

[Emre Toptancı _OBSS_]

Hello @Catalina Martinez S

The needed data is available in each issue's history but Jira does not give this as a ready-to-use report.

You can try to measure this using some automation rules. You will find many samples in many answers in this community. The downside is it is not easy to configure and maintain. It has to be configured for each workflow separately and it also works only for future issues.

You can use the Control Chart of Kanban Boards or the Average Age gadget. Those are good to give you an overall picture but have low flexibility. And they don't show individual issues.

You can try getting the data via REST and doing your own calculations. That requires serious code development.

Finally, you can try using an existing app from the marketplace.

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

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time, or Lead Time. 

You can calculate averages and sums of those durations grouped by the issue fields you select. 

  

 

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. For each report type, you can define your own calendars with your own working days, working hours, holidays, and timezone.

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

Timepiece - Time in Status for Jira

EmreT

[Mehmet A _Bloompeak_]

Hi @Catalina Martinez S ,

It is not possible using the built-in JQL functionalities of Jira. So we developed Status Time marketplace 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.