Detailed Time Spent reports by User Story with Tasks and Bugs
- Reports based on Time spent
- Detailed Time Spent reports by Release, Iteration, Team Iteration
- Detailed Time Reports for Hierarchical Entities
- Tabular Report with Detailed Time List: add Custom Columns based on Metrics
- Data Fields in Detailed Time Reports
- Detailed Time Spent reports by Feature, by Epic, by Portfolio Epic
- Detailed Time Spent reports by Work Item with Relations
- Detailed Time Reports
With Time Tracking practice enabled, Targetprocess users post actually spent time against various entities. Users submit Time records for User Stories, Tasks and Bugs. User Stories in Targetprocess include Tasks and Bugs, and project managers are interested in detailed reports with all the records grouped per user story. In Targetprocess it is possible to build detailed time report with proper grouping.
Detailed time reports are based on Times data source and operate with lists of time spent records. Time entities have predefined and custom data fields. The fields are used for reporting, grouping, and filtering. In Time records submitted to Tasks and Bugs there are no prefefined fields having reference to user stories. To build time reports with distribution per parent entity use custom calculations based on custom formula metrics or Visual Reports calculations.
Custom calculations for Visual Reports are configured and modified by any Targetprocess user (report owner). To get calculated totals displayed in other places but reports: detailed views and legacy tabular reports, set up custom formula metrics. They are configured and modified by Administrators only.
Click + Create > Report to start building new Visual report.
In the top right corner, select Projects and Teams you're interested in.
Add custom formula User Story Name to Data fields list.
Bugs not included (simple case):
CASE WHEN UserStory.ID != NULL THEN UserStory.Name WHEN Task.UserStory.ID != NULL THEN Task.UserStory.Name ELSE "No User Story" END
Bugs included (advanced case):
CASE WHEN UserStory.ID != NULL THEN UserStory.Name WHEN Task.UserStory.ID != NULL THEN Task.UserStory.Name WHEN Bug.UserStory.ID != NULL THEN Bug.UserStory.Name ELSE "No User Story" END
Set up the report:
X axis: User Story Name
Y axis: SUM(Spent)