Time Spent Report by Project Role | Targetprocess - Visual management software

Time Spent Report by Project Role

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.

Time Spent Report by Project Role. Image 1

Create a new Project and assign users to  the Project with different Roles.

Time Spent Report by Project Role. Image 2

Assign Users to work items.

Time Spent Report by Project Role. Image 3

Post times.

UserGeneral RoleProject RolePost Time
Targetprocess AdministratorDeveloperProject ManagerUS1: 1h as Developer

US2: 2h as QA Engineer

J. SmithDeveloperDeveloperUS4: 5h as QA Engineer
S. RedDeveloperQA EngineerUS2: 6h as QA Engineer
J. BrownDeveloperDeveloperUS1: 3h as QA Engineer

US2: 4h as Developer

Time Spent Report by Project Role. Image 4

Set up a new Visual Report.

Time Spent Report by Project Role. Image 5

Create this new Report based on Project Members as the data source, filtered by Project1 (P1).

Time Spent Report by Project Role. Image 6

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)

Time Spent Report by Project Role. Image 7

Move `TimesSpentProject` to the vertical(Y) axis.

Move the Role field to the Label encoding selector.

Time Spent Report by Project Role. Image 8

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.

Time Spent Report by Project Role. Image 9

Success! We now have the report we need.

Still have a question?

We're here to help! Just contact our friendly support team

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.