How to create average age report , that gives result in hours not in days

[Sai kumar]

How to create average age report , that gives average age of the tickets in hours not in days.

tried selecting hourly in period, but still giving report in days. 

[Zoryana Bohutska _SaaSJet_]

Hi @Sai kumar 

Also, you can consider alternative solution Time in Status for Jira Cloud by SaaSJet.

This tool lets you view average time in status data in time format you need: DHM (Days, Hours, Minutes), HM (Hours, Minutes), h:m (hours:minutes), M (Minutes), Decimal Hours etc.

Additionally, this app calculates other reports that could be useful for you: time in status (+total time at all statuses), assignee time, status entrance date, time in status per date, status count and transition count.

All reports are available for Charts view and as Gadget for Jira Dashboard.

Hope it helps

Best regards

Zoryana

[Emre Toptancı _OBSS_]

Hello @Sai kumar 

If you are interested in a ready built solution, our team at OBSS built Time in Status 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, Cycle Time or Lead Time. All durations can be display in various formats including days, hours, minutes even seconds.

The app can calculate averages and sums of those durations grouped by issue fields you select. (For example see the average InProgress time per project and per issuetype.). 

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.
• See Time in Status data and charts for each issue as a tab on issue view screen.

https://marketplace.atlassian.com/1211756

EmreT