Show only subtasks if the parent issue is in specific status

Hi,
I would like to create a report that will only show the list of subtasks in differrent statuses [as folllows] if the parent status is on Monthly prioritization state.


Note project is aggregated components

Thanks for your advise.

Hi @Jim

In this case, you could try introducing new linked field dimension “Parent status”
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions#Issuelinkfielddimensions-ParentStatus

Then you could filter the report by “Parent status” dimension and all sub-tasks will be filtered by the status of their parent.

Martins / eazyBI

1 Like

Thanks Martins this works

Hi @martins.vanags ,
after enabling the Parent status, i have created an aggregate filter to only show sub-tasks of parent in “NO Decision” and “1st Prioritization”.

Aggregate(
{[Parent Status].[No Decision],
[Parent Status].[1st Prioritization]
}
)

However, i am getting “No data Found” when i am trying to drill down and only showing list in a particular status only [e.g. only No Decision] even though i selected the aggregated filer.

Any advise?

thanks

@Jim
Please export and share the formula for your report that shows “No Data found”
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions

Martins / eazyBI