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

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

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

Get Started for free

Manage complex work, projects and products with Targetprocess

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Live demo

With our product specialist Ksenia