Average Time Report in Jira πŸš€

Valeriia_Havrylenko_SaaSJet
Atlassian Partner
January 12, 2024

In this article, let's dive deeper into a significant Jira metric: the average time, which indicates the average duration required to finish a task. This metric proves valuable for assessing team productivity and identifying areas for improvement.

*in this article I'm talking about the reporting capabilities of Time in Status for Jira Data Center. Time In Status for Cloud has more reporting capabilities.

giphy

  • What is the average time your team spent to finish the project? 

  • What is the average response time for customer support inquiries?

  • What is the average time it takes to resolve reported issues or bugs?

  • What is the average lead time or average cycle time for delivering products?

  • What is Average Age for tickets?
  • Or what is the average time it takes to close sales deals?

Do these questions sound familiar to you? So, let's figure out what average time metrics you can get in Jira.

What is the Average Time in Status report?

The Average Report provides a comprehensive view of the average time an issue spends in each status. This data is presented in an easily understandable format, enabling teams to identify patterns and trends quickly. 

How Average Time report works?

  • We count the number of tasks that have been in a particular status (To-Do status in this case) (green line),

  • Then, sum the time of these tasks (blue line). We take into account only those tasks that have been in the status.

  • Divide the total time by the number of tasks. (1/2)

The picture shows the logic of calculating the Average time.

average time in status calculation.png

 How to get the Average time in status report?

You can easily measure it with the Time in Status for Jira add-on. Simply select the Average Time report, apply relevant filters and get the ready report. This article helps you to get Average Time Report for Data Center version. Here you can read more about Average report in Time in Status for Jira Cloud.

Average time in Jira .png

What is the average time in state by filter?

This report shows the average time spent in a particular status in the chosen filter. You can filter your report by board, by week, open and unassigned etc. 

average time report filter by board .png

What is the average time spent by project?

How long does it take on average for your team members to complete a project? Easily get the answer with Time in Status for Jira. You can select any dates for the time reporting period.

average time per issue in Jira.png

How to Export Average time in status data?

Click to Export data as XLSX or CSV. So you can analyze all these reports in detail by exporting data to Excel, Google Sheets and Power BI.

export average time per status Jira .png

Takeaway

The Average Time in Status report will give you more transparency into how your team spends their time, empowering project managers and teams to optimize their workflows, enhance efficiency, and deliver projects on time. By leveraging this metric, you can gain valuable insights into your project's progress and make data-driven decisions to drive success.
Try Time in Status for Jira to identify and scale up positive, productive changes πŸš€

giphy

See you! πŸ‘‹

1 comment

Comment

Log in or Sign up to comment
Frankie C.
Contributor
February 15, 2024

Solid feature set, thanks for posting! 

Also - Bonus points for the Simpsons giphy πŸ‘

Like β€’ Valeriia_Havrylenko_SaaSJet likes this
Valeriia_Havrylenko_SaaSJet
Atlassian Partner
February 16, 2024

@Frankie C. Thank you! 😌
Glad to hear it! πŸ₯³ 

TAGS
AUG Leaders

Atlassian Community Events