- Reports based on Time spent
- 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 User Story with Tasks and Bugs
- Detailed Time Spent reports by Feature, by Epic, by Portfolio Epic
- Detailed Time Spent reports by Work Item with Relations
- Detailed Time Spent reports by Release, Iteration, Team Iteration
This article describes how to build a Visual Report on time spent using stacked bars split by color based on the Project Role of the user that submitted the time records. The report is related to single Project only. Times can be filtered by Date of submission.
Add Users to the system: their Default Role is Developer.
Create a new Project and assign users to the Project with different Roles.
Assign Users to work items.
|User||General Role||Project Role||Post Time|
|Targetprocess Administrator||Developer||Project Manager||US1: 1h as Developer
US2: 2h as QA Engineer
|J. Smith||Developer||Developer||US4: 5h as QA Engineer|
|S. Red||Developer||QA Engineer||US2: 6h as QA Engineer|
|J. Brown||Developer||Developer||US1: 3h as QA Engineer
US2: 4h as Developer
Set up a new Visual Report.
Create this new Report based on Project Members as the data source, filtered by Project1 (P1).
Move the User value to the horizontal(X) axis.
Define a `TimesSpentProject` formula: Times posted within given time period, per User, in Project. Use one of the alternatives below:
Related interval - last 30 days:
User.Times.Where(Project.Name = "Project1" and Date > TODAY - 30 DAYS).Sum(Spent)
Starting from some date, MM-DD-YYYY format:
User.Times.Where(Project.Name = "Project1" and Date >= DATE('01-01-2017')).Sum(Spent)
Times in dates range, MM-DD-YYYY format:
User.Times.Where(Project.Name = "Project1" and Date > DATE('12-31-2014') and Date <= DATE('12-31-2015')).Sum(Spent)
Move `TimesSpentProject` to the vertical(Y) axis.
Move the Role field to the Label encoding selector.
Now we see a summary of Times per User, Role is included.
Alternatively, we can summarize by Role. Swap the Role and User fields between the horizontal axis and color encoding selector. Switch the chart to stacked bar mode.
Success! We now have the report we need.