Detailed Time Spent reports by Release, Iteration, Team Iteration

With Time Tracking practice enabled, Targetprocess users post actually spent time against various entities. Users submit Time records for User Stories, Tasks and Bugs, while project managers are interested in totals for Releases, Sprints, Team Iterations. 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 there are no prefefined fields having reference to releases, sprints, and team iterations. 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.

Visual Reports

Click + Create > Report to start building new Visual report.

In the top left corner, select Projects and Teams you're interested in.

Data source: Times

Report by Release

Add custom formula Release Name to Data fields list.

Bugs not included (simple case):

CASE
 WHEN UserStory.Release.ID != NULL THEN UserStory.Release.Name
 WHEN Task.Release.ID != NULL THEN Task.Release.Name
 ELSE "No Release"
END

Bugs included (advanced case):

CASE
 WHEN UserStory.Release.ID != NULL THEN UserStory.Release.Name
 WHEN Task.Release.ID != NULL THEN Task.Release.Name
 WHEN Bug.Release.ID != NULL THEN Bug.Release.Name
ELSE "No Release"
END

Set up the report:

X axis: Release Name

Y axis: SUM(Spent)

Report by Iteration (Sprint)

Add custom formula Iteration Name to Data fields list.

Bugs not included (simple case):

CASE
 WHEN UserStory.Iteration.ID != NULL THEN UserStory.Iteration.Name
 WHEN Task.Iteration.ID != NULL THEN Task.Iteration.Name
 ELSE "No Iteration"
END

Bugs included (advanced case):

CASE
 WHEN UserStory.Iteration.ID != NULL THEN UserStory.Iteration.Name
 WHEN Task.Iteration.ID != NULL THEN Task.Iteration.Name
 WHEN Bug.Iteration.ID != NULL THEN Bug.Iteration.Name
ELSE "No Iteration"
END

Set up the report:

X axis: Iteration Name

Y axis: SUM(Spent)

Report by Team Iteration (Team Sprint)

Add custom formula Team Iteration Name to Data fields list.

Bugs not included (simple case):

CASE
 WHEN UserStory.TeamIteration.ID != NULL THEN UserStory.TeamIteration.Name
 WHEN Task.TeamIteration.ID != NULL THEN Task.TeamIteration.Name
 ELSE "No Team Iteration"
END

Bugs included (advanced case):

CASE
 WHEN UserStory.TeamIteration.ID != NULL THEN UserStory.TeamIteration.Name
 WHEN Task.TeamIteration.ID != NULL THEN Task.TeamIteration.Name
 WHEN Bug.TeamIteration.ID != NULL THEN Bug.TeamIteration.Name
ELSE "No Team Iteration"
END

Set up the report:

X axis: Team Iteration Name

Y axis: SUM(Spent)