How to create a reporta for a jira project Work in process to done skipping some statuses in between

[Vera Valshonok]

Hi

How can create a report for a jira project  to show time it took for the task to get from Work in process to done status skipping some statuses that I will choose in between (not to count in those statuses?

[Vitalii_Bobak_SaaSJet · Accepted solution]

Hi @Vera Valshonok 

I noticed that you've been exploring similar questions in the community and have received some add-on recommendations. If you'd like, I’d be more than happy to help you set them up and make the process easier for you. Just let me know!

If you are open to add-ons, we have one exactly for your needs -- Time Metrics Tracker | Time Between Statuses. Here's how to set it up:

1. Configure Your Metrics: In Time Metrics Tracker, you can create a custom metric to measure the time taken between “Work in process” and “Done” while excluding specific statuses. You can customize which transitions to count and which to skip.

2. Set Up the Exclusions: In the configuration, specify the statuses you’d like to exclude from the time calculation, ensuring they don’t impact your overall report.

3. Generate the Report: Once configured, the add-on will provide you with a detailed report showing the time taken, excluding the selected statuses, and you can visualize the data in various formats.

This approach provides more flexibility and insight into your workflow. Let me know if you need further assistance or have any questions about setup!

I hope this helps!

You can also book a live session or contact us at Support - we'll help you with add-on. 

Add-ons developed by my team.

I hope you find this helpful 🚀

[Madhu_RVS · Accepted solution]

Hi @Vera Valshonok 

For better flexibility in reporting, if you would be interested in a mktplace app, you may want to try out our app.

Time in Status Reports 

The app has more than 20+ reports to meet a variety of use cases. For your requirement, you can easily create a status group with only the statuses you are interested in. And the app will calculate the total time in each of those statuses and display in the report.

More details here

Disclaimer : I work for the vendor who built this app

[Vera Valshonok]

Great, I understood that I can do it with the help fo SLA and dashboard gatgets.

[Mehmet A _Bloompeak_ · Accepted solution]

Hi @Vera Valshonok

As far as I understand, what you are looking for is a cycle time (the time it takes for the team to start working on an issue and complete it) report. 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 calculate cycle 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 Cycle Time for Each Issue report. You can choose the statuses that you want to include in cycle time calculation.

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:

• 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 Reports Free.

Hope it helps.

[Danut M _StonikByte_ · Accepted solution]

Hi @Vera Valshonok,

Unfortunately this cannot be done by using Jira's default reports or dashboard gadgets. 

My advice is to search on Atlassian Marketplace for a plugin that offers such functionality in form of Jira report or dashboard gadget.

If you consider the idea of using a plugin, our Great Gadgets app offers a Time in Status gadget that can display a Data tab, showing a detailed report, which can be exported in CSV for further processing. 

This gadget allows you to exclude specific statuses:

The result is display in form of an overall chart, but on the Data tab you will see the report, with all the issues and the duration in each statuses. 

See also: https://community.atlassian.com/t5/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut.  

[Gizem Gökçe _OBSS_ · Accepted solution]

Hello @Vera Valshonok ,

Jira's native functionality doesn’t provide a direct way to calculate time spent between two statuses while skipping certain intermediate statuses. With Jira’s built-in tools, you can track the total time spent in each status using reports like the Control Chart. However, it doesn’t allow you to exclude specific statuses or calculate the total time between two statuses while skipping intermediate ones.

Solution with Timepiece

For a precise and flexible solution, I recommend Timepiece - Time in Status for Jira, the oldest and leading 'Time in Status' app in the Atlassian Marketplace, developed by my team at OBSS.

With Timepiece, you can use the Duration Between Statuses Report to achieve your goal.

This report calculates the time it took for tasks to move from “Work in Process” to “Done” while excluding specific statuses of your choice in between. You can configure the report to ignore statuses like “Blocked” or “On Hold,” ensuring only the time in active progress is considered.

Timepiece is available for both Jira Cloud and Data Center. 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.

Best regards,
Gizem