Calculating the Average Time an Issue Has Been with the Assignee

📝 Context: Calculating the average time an assignee has been assigned to a particular issue is crucial for understanding workload distribution and identifying potential bottlenecks. This guide provides step-by-step instructions to generate this report using the Time in Status app.

📝 Context: Calculating the average time an assignee has been assigned to a particular issue is crucial for understanding workload distribution and identifying potential bottlenecks. This guide provides step-by-step instructions to generate this report using the Time in Status app.

🤔 User Problem: Users need a way to calculate the average time an assignee has been assigned to a particular issue to understand workload distribution and identify areas for improvement.

🤔 User Problem: Users need a way to calculate the average time an assignee has been assigned to a particular issue to understand workload distribution and identify areas for improvement.

If you need to calculate the average time an assignee has been assigned to a particular issue, follow a few steps below:

  1. Choose the Time in Status report. Filter by the Assignee and choose the Assignee you want to generate data about.

image-20240828-120948.png

2. Switch to the Pivots.

image-20240828-121046.png

3. Click the Fields option.


4. Move the chosen fields to the appropriate column as it’s shown below:

Key → Rows

Assignee → Columns

Choose the Average of Time from the drop-down list in the Values column.

The Priority field is optional.  

Here’s how the Average time an issue has been assigned to the Assignee will be displayed on your screen.

📈 Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the average time an assignee has been assigned to each issue.

  • Workload Distribution: Understand how work is distributed among team members.

  • Identify Bottlenecks: Quickly identify areas where issues are frequently reassigned, indicating potential bottlenecks.

  • Customizable Reports: Tailor reports to specific needs by selecting different fields for rows, columns, and values.

📈 Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the average time an assignee has been assigned to each issue.

  • Workload Distribution: Understand how work is distributed among team members.

  • Identify Bottlenecks: Quickly identify areas where issues are frequently reassigned, indicating potential bottlenecks.

  • Customizable Reports: Tailor reports to specific needs by selecting different fields for rows, columns, and values.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now!