Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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

Avatar

Level 2

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 4

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 2

Thanks so much, Chuck! This is very helpful.

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