Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I build a report that sums up all 'Duration' days for designers across all projects for this year?

Avatar

Level 1

We're trying to forecast the total needed work days for our designers for all planned projects for the rest of the year.

Hope that makes sense.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 2

I imagine the duration information is in tasks assigned to designers across various projects. If that's the case, all you have to do is create a task report that filters based those assignments and your desired time period. Make sure you have Duration in the view and you select "Summarize this column by: Sum". Group by some date, like the planned completion date of the task. Group dates by year.

The report will be a list of all the tasks you want showing their individual duration, with the sum of all the durations appearing in the grouping bar at the top. Note that any parent tasks in the list will not have their durations included in the total, since they would already be counted in the sub-tasks. So make sure you assign designers to sub-tasks only and not to parent tasks.

Avatar

Level 1

Thanks so much, Chuck! This is very helpful.

I'm trying to be more proficient at building reports.