Tracking Assignee Time in Each Status

Owned by Iryna Komarnitska
Last updated: Aug 28, 2024 by Iryna Komarnitska
3 min read

📝 Context: To find out how long an assignee spends on each issue, you can use the Pivot Table function in the Time in Status app. This guide provides step-by-step instructions to configure the Pivot Table to display the assignee time for each issue.

📝 Context: To find out how long an assignee spends on each issue, you can use the Pivot Table function in the Time in Status app. This guide provides step-by-step instructions to configure the Pivot Table to display the assignee time for each issue.

🤔 User Problem: Users need a way to track how long each assignee spends on individual issues to understand workload distribution and identify areas for improvement.

🤔 User Problem: Users need a way to track how long each assignee spends on individual issues to understand workload distribution and identify areas for improvement.

Steps to configure:

  1. Open Time in Status app.

  2. Select Pivot Table view.

image-20240828-083657.png

3. Choose the Time in Status report and the required Project or Sprint.

4. Then click the Fields button.

In the Field menu, you can set your custom fields for Rows, Columns, Values.

5. To display Assignee time for Summary, drag and drop such fields:

  • Assignee and Issue Key → Rows

  • Time (hours) → Values 

  • Status → Columns 

 

As a result, you will get the Assignee Time per Status.

The Options section allows you to change the table's layout. Choose the form you like: Compact, Classic, or Flat.

For further analysis, you can export the pivot table to Excel.

📈 Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time each assignee spends on issues.

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

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

  • Exportable Data: Export customized reports to Excel for further analysis and sharing.

  • Improved Decision-Making: Use the insights gained to make informed decisions about resource allocation and workflow optimization.

📈 Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time each assignee spends on issues.

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

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

  • Exportable Data: Export customized reports to Excel for further analysis and sharing.

  • Improved Decision-Making: Use the insights gained to make informed decisions about resource allocation and workflow optimization.

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!