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.



Log in or Sign up to comment
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

343 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you