/
Getting Time Data by Parent with Pivot Table

Getting Time Data by Parent with Pivot Table

πŸ“ Context: Using the Pivot Table function in the Time in Status app, you can analyze the time spent on issues grouped by their Parent. This guide provides step-by-step instructions to set up a Pivot Table to get time data by parent issues.

πŸ“ Context: Using the Pivot Table function in the Time in Status app, you can analyze the time spent on issues grouped by their Parent. This guide provides step-by-step instructions to set up a Pivot Table to get time data by parent issues.

πŸ€” User Problem: Users need a way to analyze the time spent on issues grouped by their parent issues or epics to gain insights into the progress and efficiency of larger projects or initiatives.

πŸ€” User Problem: Users need a way to analyze the time spent on issues grouped by their parent issues or epics to gain insights into the progress and efficiency of larger projects or initiatives.

You need to do the following steps:

  1. Open theΒ Time in Status app.

  2. Β Select aΒ Pivot TableΒ view.

  3. Then click theΒ FieldsΒ button.

    image-20231226-141333.png

    Β 

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

  5. To get the Epic time in the issue field,Β drag and drop such fields:

  • SummaryΒ fieldΒ β†’Β Rows,

  • Parent fieldβ†’Β Rows,

  • KeyΒ field β†’Β Rows,

  • Status field β†’Β Columns

  • Sum of Time fieldβ†’Β  Values

As a result, you will get time data by Parent.

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 grouped by their parent issues or epics.

  • 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 project progress and resource allocation.

πŸ“ˆ Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time spent on issues grouped by their parent issues or epics.

  • 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 project progress and resource allocation.

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

Getting Time in Status Data by Epics
Getting Time in Status Data by Epics
Read with this
Get SLA Time Metrics
Get SLA Time Metrics
Read with this
Monitoring Employee Task Time
Monitoring Employee Task Time
Read with this
Sprint Report in Jira's Time in Status App for Comprehensive Sprint Analysis
Sprint Report in Jira's Time in Status App for Comprehensive Sprint Analysis
Read with this
Tracking Individual Assignee Time Averages
Tracking Individual Assignee Time Averages
Read with this
Custom Fields: Jira Time in Status Tracking for Improved Productivity
Custom Fields: Jira Time in Status Tracking for Improved Productivity
Read with this