Report for individual tickets time from open to closed

[Natalie Franklin]

Looking for a way to report on individual ticket times from the time it was created to resolved.

I see reports that are based on SLAs but they are averages.  I would like to be able to see on individual tickets the time from Created to Resolved.  

For example if I want a filter for a single user how much time was spent on individual tickets.  Then for us to be able to spit that out into excel.  I am having a hard time putting this together.

[Yuliia_Borivets__SaaSJet_]

Hi @Natalie Franklin 

You can also check out Time in Status for Jira Cloud app developed by my team. To find how much time each user spent on individual tickets, you may try the pivot table feature. Here is a short guide:

1. Select the Pivot table view.

2. Choose the Fields option.

3. Drag and drop such fields:

• Summary and Assignee → Rows
• Time (hours) → Values
• Status → Columns 

As result, you'll get a table with every team member's time spent on issues:

You can try the online demo version without installing it.

Let me know if this helps or if you have any questions.

[Mehmet A _Bloompeak_]

Hi @Natalie Franklin ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

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

[Emre Toptancı _OBSS_]

Hello @Natalie Franklin

I am afraid, this cannot be done out of the box. You will need to make your custom configuration to measure this or use one of the marketplace apps.

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 you select. (For example, see the total InProgress time per Epic or average Resolution Time per issue type). 

  

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

[Rahul_RVS]

Hi @Natalie Franklin 

One efficient solution that we have developed is Agile Tools : Epic Tree & Time in Status . It lets you display the time spent in an easy to read table. You can group the time spent by individual service desk agents, issue types, whole projects, or any other Jira issue fields.The app provides the following features

1) Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features

2) 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

[Fabian Lim]

Hi @Natalie Franklin

Out of the box you may not have any available gadgets/reports to do this. You may want to consider plugins from the marketplace.

Eazybi can do this for you: https://docs.eazybi.com/eazybijira/learn-more/learn-eazybi-through-sample-reports/samples-jira-issues/created-vs-resolved-issues-over-time

This may not be the exact report you want, but if you contact them, they will be able to assist.

Cheers

[Ilze Leite-Apine - eazyBI]

Hi @Natalie Franklin 

Thanks, @Fabian Lim for mentioning eazyBI, an app for data analysis and charts.

Indeed, eazyBI has a predefined measure "Average resolution days" (also workdays) that counts days between Created and Resolved. Used with issues in the report rows, it shows the total resolution days for each issue.

There are several reports in the eazyBI demo account with this measure:

https://eazybi.com/accounts/1000/cubes/Issues/reports/97436-issue-resolution-days-lead-time  (a table with issue types in rows, not issues, but issues can be used instead of issue types freely)

https://eazybi.com/accounts/1000/cubes/Issues/reports/91815-issue-resolution-time-boxplot-chart (resolution as a boxplot chart)

Also, there is an option to analyze data by resolution intervals, if you want to see issues split by buckets based on their resolution intervals, an example here https://eazybi.com/accounts/1000/cubes/Issues/reports/50399-issue-resolution-intervals-lead-time

Feel free to contact support@eazybi.com for further assistance or any questions!

Best,

Ilze // support@eazybi.com