Timestamp for Status

Question

I want to generate a report in Jira for Bug issues that includes timestamps. Specifically, I need to calculate the total time each bug spends in all four of its workflow statuses, as well as the transition time from one status to the next. How can I achieve this?

Iryna Komarnitska_SaaSJet_ · Answer

Hi @Ashwin Kurundkar ,

If you’re open to using a third-party app, you might want to try Time in Status (developed by my team).

It helps you generate detailed time-in-status reports for any work item types, so you can see exactly how long issues spend in each workflow step. This makes it easier to spot bottlenecks, compare performance across teams or projects, and understand where time is being spent throughout the process.

Hope you find it useful!

Birkan Yildiz _OBSS_ · Answer

Hey @Ashwin Kurundkar

To see the time a bug issue spends in each workflow status and the exact transition timestamps directly in Jira, you would normally need to review each issue’s history. However, doing this manually is time-consuming and error-prone. Instead, you can use Timepiece - Time in Status for Jira.

To calculate the total time each bug spends in all four of its workflow statuses, you can use Timepiece’s Status Duration and/or Duration Between Statuses reports.

With Status Duration Report, you can see how long each bug spent in every status. You can track the time spent in each status individually, helping to identify bottlenecks and understand workflow efficiency. Specific statuses can also be excluded from the calculation if needed.

With Duration Between Statuses Report, you can create a consolidated column by selecting statuses to include. You can calculate the total duration across the selected statuses.

To see transition time:

Timepiece has a different type of report for it: Date reports.

With Timepiece, you can see the first and last transition reports to see the exact dates each issue transitioned to or from a status.

I hope this is helpful. Please let me know if you have any follow-up questions. To check it out, you can visit Timepiece’s Atlassian Marketplace page.

Disclosure: I am part of the OBSS team, the creators of Timepiece.

Best,Birkan

Anastasiia Maliei SaaSJet · Answer

Hi @Ashwin Kurundkar

If you are looking for a straightforward way to get these timestamps and calculations, I recommend trying Time Metrics Tracker (developed by my team at SaaSJet). It was specifically designed to measure workflow connections and transition times.

Here is how it can help with your specific request:

- Custom Cycle and Lead Time: You can count the time between any two points in your workflow by setting start, stop, and pause statuses. To get highly detailed data, you can even select the first or last transition to/from a specific status.

- Business Hours & Calendars: You can configure your working hours so that the report only counts the time your team is actually working, excluding weekends and holidays.

- Visual Time Limits: You can determine time limits for specific transitions to highlight overdue issues, making it easy to spot bugs that are stuck.

- Full Control Over Timers: You have the flexibility to set start/stop/pause timers to get the exact "Time in Status" data you need.

I'd be happy to help if you have any questions about setting up your specific bug-tracking metrics!