/
Tracking Spent Time in Each Issue Field

Tracking Spent Time in Each Issue Field

šŸ“ Context: Using the Pivot Table function in the Time in Status app, you can customize and analyze the time spent on issues based on various fields. This guide provides step-by-step instructions on how to set up a Pivot Table to get the issue time for each field.

šŸ“ Context: Using the Pivot Table function in the Time in Status app, you can customize and analyze the time spent on issues based on various fields. This guide provides step-by-step instructions on how to set up a Pivot Table to get the issue time for each field.

šŸ¤” User Problem: Users need a way to analyze the time spent on issues based on different fields to gain insights into their workflow and make data-driven decisions.

šŸ¤” User Problem: Users need a way to analyze the time spent on issues based on different fields to gain insights into their workflow and make data-driven decisions.

You need to do the following steps:

  1. OpenĀ Time in Status app.

  2. Ā Select aĀ Pivot TableĀ view.

    Ā 

  3. Then click theĀ FieldĀ button.

    image-20231226-134105.png

    4. In theĀ FieldĀ menu, you can customize data presentation by setting your customĀ fieldsĀ forĀ Rows, Columns, and Report Filters.

    To get the time in the issue field,Ā drag and drop such fields:

    • Summary or Issue KeyĀ fieldĀ ā†’Ā Rows,

    • Time (hours)Ā ā†’Ā Values

    • Type of issue fieldĀ ā†’Ā ColumnsĀ 

You can select any issue field: Priority, Sprint, Issue type, Flagged, Fix version, etc.

As a result, you will get theĀ time when an issue has each type of issue field you selected.

image-20231226-134858.png

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

image-20231226-134914.png

šŸ“ˆ Outcomes:

  • Detailed Analysis:Ā Get a detailed breakdown of the time spent on issues based on various fields.

  • 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 and optimize workflows.

šŸ“ˆ Outcomes:

  • Detailed Analysis:Ā Get a detailed breakdown of the time spent on issues based on various fields.

  • 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 and optimize workflows.

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