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

SOLVED

Grouping by highest level "parent"

Avatar

Level 2

I am trying to run a task report to show task due in certain time frames (this week/overdue, next two weeks, etc.) I need those tasks to always GROUP by the highest-level parent (parent, grandparent, great grand parent.) However not all tasks have the same levels of sub-tasks. So some do not have grand-parents, and my current grouping is showing "Parent:Parent: No Value". I just want it to skip it if i there is no grand-parent and go to the parent.

Here is the grouping so far, any suggestions? Basically I need "If no grand parent, show parent" in the grouping instead of "no value"

textmode=true

group.0.displayname=Parent

group.0.namekeyargkey.0=Parent

group.0.namekeyargkey.1=name

group.0.valuefield=parent:parent:name

group.0.valueformat=string

group.0.namekey=view.relatedcolumn

group.0.linkedname=parent

group.1.valuefield=parent:name

group.1.displayname=Parent

group.1.linkedname=parent

group.1.namekey=view.relatedcolumn

group.1.valueformat=string

group.1.namekeyargkey.0=Parent

group.1.namekeyargkey.1=name

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Erin -

Try this:

group.0.name=Highest Parent

group.0.valueexpression=IF(ISBLANK({parent}.{parent}.{parent}.{name}),IF(ISBLANK({parent}.{parent}.{name}),{parent}.{name},{parent}.{parent}.{name}),{parent}.{parent}.{parent}.{name})

group.0.valueformat=HTML

textmode=true

If there are tasks with more than great-grandparent tasks, you will need to add another if isblank statement onto this.

Hope that helps!

View solution in original post

0 Replies

Avatar

Level 2

I would love to hear back on this one too! There are so many things that I would like to see grouped by the highest parent group.

Avatar

Correct answer by
Employee

Hi Erin -

Try this:

group.0.name=Highest Parent

group.0.valueexpression=IF(ISBLANK({parent}.{parent}.{parent}.{name}),IF(ISBLANK({parent}.{parent}.{name}),{parent}.{name},{parent}.{parent}.{name}),{parent}.{parent}.{parent}.{name})

group.0.valueformat=HTML

textmode=true

If there are tasks with more than great-grandparent tasks, you will need to add another if isblank statement onto this.

Hope that helps!

Avatar

Level 9

This is very good @Sarah Nau‚ and @Erin McMurray‚

But if we want to group by parent task only one level up not grand parent in the report. Then could you suggest what will be the group expression code for that?

Thanks and regards,

Kundan.

Avatar

Employee

Hey Kundan,

You should be able to group by parent task name without going into text mode. Under groupings, find parent and within that section find name. You may want to filter out parent tasks (number of children = 0) since these would show in a 'no value' grouping on your report.

Hope that helps!