Showing results forย 
Search instead forย 
Did you mean:ย 
Sign up Log in

Time in Status per Assignee using a Pivot table function ๐Ÿš€ [Use Case #3]

If you're a businessman, you may face the problem of identifying the effectiveness of your subordinates. What does it mean? Letโ€™s determine 2 important features of effectiveness:

  • How much time does it take a person to solve each task?
  • How long a task has been spent in different statuses (To Do, In Progress, On Hold, etc)?

When you are informed that there is a person who does the job three times longer, you should discover why does it happen, shouldnโ€™t you?

Time in Status for Jira Cloud can help you to identify the issues described above. You need to use Time in status per assignee filtering using the Pivot Table option. Here is a step-by-step guide:

  1. Open a Time in Status for Jira Cloud app.
  2. Choose a Pivot Table view.
    time in status per assignee.jpg
  3. Click on a Field's button.
    jira reports fields.jpg
  4. In the Field menu, you can choose how the data is presented by setting your custom fields for Columns, Rows, Report Filters.
    To get the time in the issue field, drag and drop such fields:
    • Summary or Issue Key โ†’ Rows,
    • Time (hours) โ†’ Values
    • Status and Assignee โ†’ Columnsusing pivots in time in status jira.jpg
      pivot function jira.jpg

As a result, you will get the Time is status per Assignees. The time in each status for different assignees will be shown on a grid.

time in status by assignee.jpg

You can export a generated report to Excel or PDF files.export calculated data in jira.jpg

Using this data, you can compare the time values for different people. Identify who spends too much time on solving tasks to prevent bottlenecks in the working process. Time in Status for Jira Cloud is a handy solution to track time in status, identify bottlenecks and compare different types of data. You can get the add-on on the Atlassian Marketplace.

1 comment


Log in or Sign up to comment
Zoran Vujcic
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 18, 2022

Thank you! This article was really helpful.


AUG Leaders

Atlassian Community Events