Report on Epics with specific issuetypes underneath them

We have define a special IssueType we call “Plan”, which is used for storing planning data. Is there a way I can build reports on epics that have Plan issues as children? I know I can filter for IssueType = Epic, but how to I further filter to only show epics that contain one or more issues, where IssueType = Plan?

Thanks for the help!

Hi,

In this case, you could try using the ‘Epic’ hierarchy from “Issue” dimension to display epics and then create a new calculated member in “Measures” dimension that would counter only epic’s children with specific issue type.
Try this code:

(
  [Measures].[Issues created],
  [Issue Type].[Plan]
)

Next, you could select your new calculated member in columns and filter report rows by this column to display only epics which have at least 1 Plan issue among their children.

Best regards,