Expand my Community achievements bar.

SOLVED

Help | Parent Task Planned Duration Report

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

3 Replies

Avatar

Level 10

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

_Manish_Singh_0-1746504500400.png

Avatar

Level 2

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

Correct answer by
Level 10

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