nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

I would like to know how much time a ticket has been in a certain Status

Mario Sanchez_no55j6

Hello

Bear with me till the end, it gets more complicated than this:

I would like to know the time the ticket has been in certain status.

To make it easier I will simplify with an example. I have a Workflow with 3 Status (In Progress, Waiting for response, Resolved)

If I have a ticket 2 hours in status "In Progres" and then changes to "waiting for response". I need a variable that will say, "Time in status In Progress" = 2 hours. Now if the ticket starts 2 hours in "in Progress", then changes to "Waiting for response" for 1 hour and then comes back to "In progress" for another 2 hours before being moved to "waiting for response" again. The variable now should show 4 hours.

now if I look at that variable while the ticket it still in the status "In progress" it should add me up all the previous times the ticket has been in that status + the time it still is in that status.

Why do I want this, its because if I want to organise in a queue for the amount of time the tickets have been and still are in the status "in Progress" without counting the time they have been outside.

I accept if the varible is not continuous but could update with the time when you click it.

I was trying with some Date time pick variables and adding up and substracting time but never managed to write the proper JSON in the automation.

thanks a lot in advance

Accepted answers

All comments

Mehmet A _Bloompeak_

Hi @Mario Sanchez

Welcome to the Atlassian Community!

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 Time in Status for Each Issue report. For further details, please see Status Time Reports How to Videos.

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

Hope it helps.

Marin Varvodic

Hi @Mario Sanchez

we have this feature in our FREE app providing custom fields in Forge. https://marketplace.atlassian.com/apps/1225290/custom-field-suite-powerful-custom-fields-for-jira-free?hosting=cloud&tab=overview

RVS_Support

Hi @Mario Sanchez

Welcome to the community !!

If you are fine to try out a mktplace app for this use case, take a look at

Time in Status Reports

The app has 20+ reports to meet a variety of use cases.

Do try it out.

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

Valeriia_Havrylenko_SaaSJet

Hі @Mario Sanchez

As an alternative, you can try Time in Status for Jira Cloud (developed by my team). The primary purpose is to help teams gather valuable data about the lifecycle of your issues in Jira. Add-on allows you to measure and visualize the time spent in each status, such as "Open," "In Progress," "In Review," and "Closed," and provide 7 types of reports to help you identify areas for improvement.

This add-on generates 7 types of time tracking report, such as

Time in Status,
Average Time, etc.
Assignee Time,

Time in status GIF.gif
You can also extract a report as XLSX or CSV files for further analyzing Excel or Google Spreadsheets easily.

Another option is Time between Statuses (developed by my SaaSJet team), which gives you ability to have the report of ticket like how many days this particular ticket stayed in a particular status

How it looks like:
Time Between Satuses.jpg

You just need to set the start/stop/pause timers to get Jira time in status data. Determine time limits to highlight overdue issues. And you will be able to send email notifications about warning issues.

After you will be able to export the report as CSV or XLSX files easily.

Add-on have a 30-day free trial version and free up to 10 users.
Please, let me know if you have any questions

Hope it helps 😌
Valeriia

Emre Toptancı [OBSS]

Hello @Mario Sanchez

Our team at OBSS built Timepiece - Time in Status for Jira exactly for this. 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.

tisCloud_StatusDuration_LeadTime_with Estimates.png

By default, the app shows the total time issues visited each status but you can also get reports on the first visit time, last visit time, average visit time, and even the number of times each status was visited.

You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc.

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.

tisCloud_StatusDuration_LeadTime_Average_TimeGrouped.png

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. It supports both Company Managed and Team Managed projects for Jira Cloud.

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.

Timepiece - Time in Status for Jira

EmreT

Paul Heath Armengol

@Mario Sanchez

If you're asking yourself ¿is this Atlassian Community or Atlassian Market? The answer is Yes.

Atlassian offers no real solutions to customers bugs and suggestions, only thousands of issues and Bugs that stay unresolved for years

Atlassian figured out time ago that it's "better" to wait for someone else to develop a custom solution and then publish it in Atlassian's Marketplace, that way Atlassian gets an extra income (a cut from the sales) with absolutely no effort.

Genius right? No? Well, get used to it.

And remember to

Vote for this issue

Start watching this issue

amitajmera777

Hi @Mario Sanchez ,

"If you're trying to figure out how long issues stay in each status, it can be tricky in native Jira. I had the same challenge and built a small app called Workflow Aging that gives this visibility — might help you spot bottlenecks quickly."

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management