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. |
---|
π€ 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:
Open theΒ Time in Status app.
Β Select aΒ Pivot TableΒ view.
Then click theΒ FieldsΒ button.
Β
In theΒ FieldΒ menu, you can customize data presentation by setting your customΒ fieldsΒ forΒ Rows, Columns, Report Filters.
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:
|
---|
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!