Expand my Community achievements bar.

Help | Parent Task Planned Duration Report

Avatar

Level 1

Hello,

 

I've built a report that captures a project's Parent tasks' planned duration. While the report does capture the Parent task's name and planned duration, I want a summation of all the subtasks' planned duration; instead, I get a duplicate line item named with the parent task. 

 

Filters: 

IsaacWu_0-1746479773559.png

 

The Report:

IsaacWu_1-1746479825740.png

 

The Project:

IsaacWu_3-1746480741950.png

So technically, I would want my report to look like this:

IsaacWu_4-1746480856816.png

 

Thanks in advance for your help!

Topics

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

3 Replies

Avatar

Level 9

Hi @IsaacWu, You can add this filter to get parent tasks only.

_Manish_Singh_0-1746504500400.png

Avatar

Level 1

Thank you for your response, Manish!

 

I've added that filter and I think it's a step in the right direction; however, now it is only tracking "Summary" which is the top-level parent task, technically. It is also duplicating it in the report: 

IsaacWu_0-1746547758736.png

 

Avatar

Level 9

Could you group the report the report by project name and see what you are getting? or apply the project filter for testing? I think the summary tasks in your screenshots are from different projects.

For example, these are the tasks from my dummy project:

_Manish_Singh_0-1746675412606.png

This is the report output with number of children greater than zero and grouped/filtered by project name:

_Manish_Singh_1-1746675444330.png