Time in status custom fields

Eran Roiter
Contributor
June 10, 2024

Hello everyone,

I would appreciate your help in finding a solution using ScriptRunner or any other method you know.

I have set up a field where I want to capture the total time a ticket spends in specific status groups. I attempted to use multiple automations to populate this field, but it didn't work, and I need to use ScriptRunner.

If anyone has tackled a similar challenge, my ultimate goal is to SUM UP the time for several tasks. For example, I want to see the total time each task spent in these status groups at the epic or initiative level as the sum of all the subtasks.

I believe I am not the first or the last to face this need and hope someone has managed to overcome this issue.

Thank you and have a good day,
Eran

6 answers

3 votes
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 10, 2024

Hi @Eran Roiter ,

Time in Status plugin seems to be the solution. Also you can check Atlassian Marketplace for other plugins

2 votes
Valeriia_Havrylenko_SaaSJet
Atlassian Partner
June 10, 2024

Hi @Eran Roiter  👋

There is no built in solution such 'time in status' in Jira for this. For capturing the total time a ticket spends in specific status groups, you can try 
Time in Status

For this simply:

  1. Select Time in Status Report 
  2. Filter by JQL like project = "name" and issuetype = Task
  3. Filter issues by setting data and time ranges (there you can set >10d for Certain Statuses)
  4. Choose necessary statuses to show. (in my project i don't have Submitted, "Section Review" instead of that i've selected "On Review", "Ready for Testing", "Testing")

Знімок екрана 2024-05-14 о 13.17.41.png

The Total column on the grid summarizes all time in statuses in which issues were during a particular period.

 

For more in-depth data analysis, you can create reports as pivots. For example, you can look at the percentage of time spent in different statuses.

Frame 1034.png

Dashboards gadgets feature will keep your finger on the pulse and track team productivity in real-time.

Frame 1028.png

And also you can create a custom field to see Time in Status directly on the board and ticket.

Знімок екрана 2023-12-14 о 16.54.48.png Знімок екрана 2023-12-14 о 16.55.09.png

 

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

I hope you find this helpful 🚀 

2 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
June 10, 2024

Hi @Eran Roiter

welcome to the community!

As you can see from the previous answers, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their status time reporting needs. 

If a Marketplace app is an option for you, I think you might like the app that my team and I are working on, JXL for Jira

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including all JSM-specific fields - much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], time with [assignee], time with [assignee] in [status], and many, many more. 

This is how it looks in action:

time-in-status-v2.gif

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, you should be able to solve your exact use case in just a couple of clicks.

You may already know that you can trial any app for free for 1 month, so if an app is an option for you, perhaps try a few and see which one works best for you and your team!

Any questions just let me know,

Best,

Hannes

2 votes
Amay Purohit_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 10, 2024

Hi @Eran Roiter 

 

You can use Jira Rest API's to build your own custom solution and track time spent by your assignees for overall issue cycle. Or for a readymade solution, a mktplace app can help here. If you are open to try out one, do take a look at

Time in Status Reports 

One of the many reports which the app provides is Time in Status in hours/days to determine , how much time the issue spent with each status in the complete lifecycle of the issue. You can also group your statuses to determine the cycle times.

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

More Details here 

Disclaimer : I work for the vendor who built this app

TIS-1.png

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
June 10, 2024

Hi @Eran Roiter

Jira doesn't have a built-in solution for time in status info. 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.

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, 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 Status Time Reports How to Videos and schedule a demo with us.

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.

Hope it helps.

0 votes
Gizem Gökçe _OBSS_
Atlassian Partner
June 10, 2024

Hello @Eran Roiter ,

There is no built in solution in Jira for this. So in order to track the time spent on each status I suggest you use a marketplace app. Timepiece (formerly Time in Status) ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need.  Our app is available for both Jira Cloud, and Data Center. 

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

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. Status Duration Report in Detail.png

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 epic or average resolution time per sprint, week, month, issue type, 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. 

Group By Created Month.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.

Timepiece 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 easily. 

Visit Timepiece (formerly 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.

Hope it helps,

Gizem

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events