Repeating Parent Task in Marketing Round Report
Hello! I managed to create a report to count the number of R1-R7 parent tasks in a report. However, when I look at it more closely, the parent tasks are repeating! I created a filter where parent tasks contain R1 OR R2 OR R3, etc., and I also grouped them by the parent task name. Is there a way to remove the repeats, because when I check the projects, they only appear once!
Grouping:
group.0.linkedname=parentgroup.0.namekey=view.relatedcolumngroup.0.namekeyargkey.0=parentgroup.0.namekeyargkey.1=namegroup.0.orientation=Hgroup.0.valueexpression=IF(CONTAINS("R1",{parent}.{name}),"R1",IF(Contains("R2",{parent}.{name}),"R2",IF(CONTAINS("R3",{parent}.{name}),"R3",IF(CONTAINS("R4",{parent}.{name}),"R4",IF(CONTAINS("R5",{parent}.{name}),"R5",IF(CONTAINS("R6",{parent}.{name}),"R6",IF(CONTAINS("R7",{parent}.{name}),"R7")))))))group.0.valuefield=parent:namegroup.0.valueformat=stringtextmode=true
What am I doing wrong? Is there a way to fix this?