/
Time in Status per Assignee with Pivot Table

Time in Status per Assignee with Pivot Table

πŸ“ Context: Using the Pivot Table function in the Time in Status app, you can analyze the time spent in different statuses per assignee. This guide provides step-by-step instructions to set up a Pivot Table to get the time in status per assignee.

πŸ“ Context: Using the Pivot Table function in the Time in Status app, you can analyze the time spent in different statuses per assignee. This guide provides step-by-step instructions to set up a Pivot Table to get the time in status per assignee.

πŸ€” User Problem: Users need a way to analyze the time spent in different statuses for each assignee to gain insights into individual productivity and workload distribution.

πŸ€” User Problem: Users need a way to analyze the time spent in different statuses for each assignee to gain insights into individual productivity and workload distribution.

You need to do the following steps:

  1. OpenΒ aΒ Time in Status app.

  2. Β SelectΒ aΒ Pivot TableΒ view.

    Β 

    3. Then click theΒ FieldsΒ button.

image-20231226-130830.png

4. In theΒ FieldΒ menu, you can customize data presentation by setting your customΒ fieldsΒ forΒ Rows, Columns, Report Filters. To get the time in the issue field,Β drag and drop such fields:

Summary or Issue KeyΒ fieldΒ β†’Β Rows,

Time (hours)Β β†’Β Values

Status and AssigneeΒ fieldsΒ β†’Β ColumnsΒ 

As a result, you will get theΒ Time is status per assignees.

image-20231226-131413.png

Β 

You canΒ Export the customized reportΒ to Excel doc or PDF format.

image-20231226-133513.png

πŸ“ˆ Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time spent in different statuses per assignee.

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

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

  • Improved Decision-Making: Use the insights gained from the Pivot Table to make informed decisions about workload distribution and team performance.

πŸ“ˆ Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time spent in different statuses per assignee.

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

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

  • Improved Decision-Making: Use the insights gained from the Pivot Table to make informed decisions about workload distribution and team performance.

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!

Request a demo call