Skip to main content
Skip table of contents

Tracking Assignee Time in Each Status

πŸ“ 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.

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.

image-20231226-133723.png

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.

image-20231226-133909.png

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.

image-20231226-133919.png

πŸ“ˆ 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!

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.