How to download the time in status report for bugs

[SriRameshNaidu Pataballa]

am looking for a report for hours/days spent on each bug status (open, in progress, QA, closed) .. a kind of defect aging. 

I tried gadget "Average Time in Status" which is not providing any thing. 

pls help me 

[Mehmet A _Bloompeak_]

Hi @SriRameshNaidu Pataballa ,

The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json, then you need to calculate it by coding which parses issue history rest api json for each issue.

Or you can search for marketplace apps which does the same for you. One of them is Status Time app developed by our team. It provides reports on how much time passed in each status and show status entry dates.

If you are looking for a free solution, you can try the limited version Status Time Free.

[Bill Sheboy]

Hi @SriRameshNaidu Pataballa 

Seeing your posts/responses about being limited from adding marketplace addons/apps to the client instance, your options to do this type of reporting are quite limited.  If the client is requesting the report, consider discussing marketplace apps with them to fill this need. 

Otherwise, the work-arounds without addon apps could be:

• If you need this infrequently you may want to do this by-hand from the issue histories
• If showing the information outside of Jira is acceptable, you could call the REST API repeatedly for the issues, and parse the results to build a report in another tool
• If you want to do this inside of Jira without marketplace apps, you could add custom fields, use Automation for Jira (A4J) rules to set the fields based on issue transitions, and then use JQL filters to report on the results

Best regards,
Bill

[Ilze Leite-Apine - eazyBI]

Hi @SriRameshNaidu Pataballa 

As other community members mentioned here, a Jira app would do the job.

eazyBI is an app for data analysis and charts.

Using that, you can analyze, among other issue information, issue changelog data, including status transition analysis and time spent in each issue status.

There are a few examples in the eazyBI demo account for reporting on time spent in each status from different viewpoints, for example:

• https://eazybi.com/accounts/1000/cubes/Issues/reports/145950-average-time-in-status-cycle-time - shows the average time spent in each status in a time period. The report shows the data for all issue types, but, selecting issue type "Bug" in the report Pages, you would get the report by bugs.
• https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status  - shows time spent in a specific status (selected in Pages) for issues; by selecting issue type "Bugs" in the report Pages, you would get data only for bugs.

To get the report into your eazyBI instance, you can export the report definition and import it into your eazyBi account: https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

More information about eazyBI: https://docs.eazybi.com/eazybijira

If you have any questions or some assistance is needed with eazyBI, please, do not hesitate to contact us support@eazybi.com.

Ilze, eazyBI Customer Support Consultant

[Emre Toptancı _OBSS_]

Hello @SriRameshNaidu Pataballa

This functionality is not available out of the box. You can try building this with custom fields and some post functions but that will be difficult to build and maintain. And that solution will work only for the issues after now.

In case you are OK with using a marketplace app, our team at OBSS built Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Server, Cloud, and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Resolution Time, Cycle Time, or Lead Time. 

You can calculate averages and sums of those durations grouped by the issue fields or time segments (For example, see the total InProgress time per Epic or average Resolution Time per month). 

  

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.

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.

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets 

Timepiece - Time in Status for Jira

EmreT

[SriRameshNaidu Pataballa]

Hi EmreT

I will not be able to make any changes to client restricted JIRA. thank you for quick response.  

[Alex Koxaras -Relational-]

Hi @SriRameshNaidu Pataballa 

There is no out of the box functionality for what you are seeking. The simplest way would be to use an app like https://wiki.almworks.com/documentation/structure/time-in-status-column-71042417.html

The other way, the more difficult, would be to create custom fields, do some automation calculations, while taking into consideration back-n-forth changes in the statuses.

I would go with the use of an app.

[SriRameshNaidu Pataballa]

Hi Alex, I am using the client owned JIRA and its restricted to install any plugins or third party apps. . any other better solution pls ? thank you for quick response. 

[Rahul_RVS]

Hi @SriRameshNaidu Pataballa 

Welcome to the community !!

This data is difficult to get out of the box. If you would be interested in a ready made solution, one cheap and efficient solution that we have developed is Time in Status Reports . It lets you display the time in each status in an easy to read table, with configurable working hours setting. The app provides the following features

 Time in Status :- More than 7 types of Time in Status reports to track your issues. You can also group your statuses to define your own cycle time/lead time/time to resolution

[SriRameshNaidu Pataballa]

Hi Rahul, thank you quick response. since am using the client owned JIRA and its restricted to install any plugins or third party apps. . any other better solution pls ? 

[Yuliia_Borivets__SaaSJet_]

Hi @SriRameshNaidu Pataballa 

You can try some other solutions to get the time in status data for Jira issues:

• Built-in Jira feature Days in Column (!Available only for classic boards). You can learn how to enable this feature here. But if you instead need to remember time measurement over time, by status (e.g., how long was I in status <X>), you would need to explore other options.
• Use custom fields and automation rules to measure the time in status.
• If something changes about using add-ons, consider Time in status for Jira Cloud.