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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

Thank you! This article was really helpful.



Log in or Sign up to comment

Atlassian Community Events