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.

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

Assign Users to work items.

Post times.

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.