/
Getting Time in Status Data by Epics

Getting Time in Status Data by Epics

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

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

šŸ¤” User Problem: Users need a way to analyze the time spent on issues grouped by 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 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-140305.png

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

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

  • SummaryĀ fieldĀ ā†’Ā Rows,

  • Epic fieldā†’Ā Rows,

  • KeyĀ field ā†’Ā Rows,

  • Status field ā†’Ā Columns

  • Sum of Time fieldā†’Ā  Values

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

image-20231226-140821.png

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

image-20231226-140332.png

šŸ“ˆ Outcomes:

  • Detailed Analysis: Get a detailed breakdown of the time spent on issues grouped by 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 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!

Request a demo call