Bug Age Calculator

[sravani vennapusa]

I want to calculate the Bug age from creation to closed . But I want to exclude the time when the status is kept On hold. Can someone Suggest on this.

[Rahul_RVS]

Hi @sravani vennapusa 

Welcome to the community !!

If you would like to try out a mktplace app for this requirement, pls explore

Time in Status Reports 

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. It works for current issues and closed ones as well.

With Status grouping feature, can help you define your own cycle time / issue age time and view the averages of the same. You can add your specific statuses to the status group to calculate the bug age. Also the app has 20+ reports to meet a variety of use cases.

You can set your own working calendar to exclude weekends and holidays from the time in status calculation.

More details here.

Disclaimer : I am part of the app team for this add-on 

[Bill Sheboy]

Hi @sravani vennapusa -- Welcome to the Atlassian Community!

What problem are you trying to solve with this measurement?  That is, "why do this"?  Knowing that may help the community offer better suggestions.

Until we know that "why"...

The measure of total duration from Created to Closed / Completed is called the "Lead Time", and it helps teams considering process improvement changes / methods.  For example, when the team makes process changes they can compare the before and after time measures to evaluate impacts.

However, removing time for a work item in a "On Hold" status conceals part of the processing where work is waiting (i.e., delays).  That makes evaluating process improvements both more difficult and not representative of the actual impacts.  This could mislead the team and stakeholders.  For a step where work is waiting, it may be better to evaluate why waiting occurs (e.g., with root cause analysis), and consider how to reduce / eliminate that step.

As noted earlier, knowing why you want to do this will improve community suggestions.  In the meantime, please consider discussing your scenario with your team's agile / process coaches to learn their thoughts.  Thanks!

Kind regards,
Bill

[Danut M _StonikByte_]

Hi @sravani vennapusa,

Welcome to the Atlassian Community. 

Jira does not provide an out-of-the-box report specifically designed to calculate “time in status” while excluding selected statuses.

With Atlassian Analytics (an enterprise/premium feature), you may be able to build a custom chart that excludes specific statuses, but this usually requires custom queries/SQL.

Alternatively, apps from Atlassian Marketplace often support this directly out of the box.

If you want to use an app, this can be easily achieved by using the Time in Status gadget offered by our Great Gadgets app. Here is an example, with the average bug age split by priority:

On its Data tab, this chart will display a table with the bugs, their age and time in every workflow status.  

In its configuration settings, the gadget allows you to exclude certain statuses such as "On hold":

Hope this helps.

Danut.

[Enric Font]

Dear @sravani vennapusa 

I you can get the time each work item remains in each status you can use the SLA report of the Gadget Utilities for Jira Cloud

You can select the filter of work items to display and add the statuses you can track