/
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.

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

๐Ÿ“ˆ 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!



Related content

Current Week's Time in Status Report
Current Week's Time in Status Report
Read with this
Cycle and Lead Time for Jira Issues
Cycle and Lead Time for Jira Issues
Read with this
Displaying Days Instead of Hours in a Pivot Table
Displaying Days Instead of Hours in a Pivot Table
Read with this
Time and Story Points Estimation Using Pivot Table
Time and Story Points Estimation Using Pivot Table
Read with this
Understanding Business Decimal Days Calculation
Understanding Business Decimal Days Calculation
Read with this