How to createa report that shows the age of the issue

[John Charles]

Needs to create a report that shows the age of the incidents - to identify long standing issues in the team queue

[Jack Brickey]

Excel is your friend here. While you can certainly use an addon, Excel is free if you already have access and if not you can use Google Sheets. The nice thing about excel is that you can use the plugin to run a query directly from Excel. Just open Excel and click Insert > Addins and find Jira addin. More here - jira-cloud-for-excel-official 

[Mehmet A _Bloompeak_]

Hi @John Charles ,

You can try below 2 apps available at Atlassian Marketplace.

Status Time: It generates status time report based on a calendar(7/24 or your working calendar). You can see it on online demo here.

Status Time Free : Limited but free version of the above.

[Mariana_Pryshliak_Saasjet]

Hello, @John Charles 

You can try Time in Status for Jira Cloud. This add-on generates a few detailed reports about issues. 

Time in Status report shows detailed info about statuses.  In the "Total" column you can find the age of a particular issue.

 

Besides this info, you can see the status age and the date when an issue has entered each of the statuses for the first time in the Status Entrance Date report. 

So you can identify the age of the issue - from creating till solving.

Moreover, you can view data both in Gadget for the Jira dashboard and in Charts.

I hope, this is actually what you need.

If you have any additional questions, contact me.

Best regards, Mariana

[Emre Toptancı _OBSS_]

Hello @John Charles ,

If you are interested in a ready built solution, 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 or group. You can combine statuses into consolidated columns to see metrics like Age, Resolution Time, Cycle Time or Lead Time. For these metrics, you can individually select which statuses to include or exclude. All durations can be display in various formats including days, hours, minutes even seconds.

You can get the report for a project, a user, for a saved filter or even a custom JQL query.

It can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average Cycle Time per project and per issuetype or see the sum of InProgress time per component). 

Time in Status uses Jira issue histories to calculate its reports so you can use the app to get reports on your past issues as well.

The app has custom calendar support so you can get your reports based on a 24/7 calendar or your custom business calendar. (This one is important because a 24/7 calendar in most cases shows misleading data. For example an issue created at 16:00 on Friday and was resolved at 09:00 on next Monday seems to stay open for 2,5 days but in terms of business hours, it is only a few hours. You can see this using Time in Status by OBSS.)

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. Get metrics like Lead Time or Cycle Time.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example see average InProgress time per project and per issuetype.)
• Export your data as XLS, XLSX or CSV.
• Access data via REST API.
• Use one of various charts type for your reports.

Timepiece - Time in Status for Jira

EmreT