Reporting on all activities beneath a specific Jira Phase

Hey team,

I am trying to develop a range pf reports that allow to track activities beneath a specific phase. For example, Phase issue type abc-123 has a number of issues underneath at various layers.

I have tried the below as a calculated measure:

Aggregate(
Descendants(
[Issue].[abc-123],
[Issue].[Issue]
)
)

This didn't show any issue under abc-123.  So I then tried:

Aggregate(
  Filter(
    Descendants([Issue].[abc-123], [Issue].[Issue]),
    [Measures].[Issue Type] <> "Epic"
  )
)

Again, no result.


I then tried this:
NonZero(Count(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issue Parent] = "ABC-123"
  )
))
Again no response.

Are there any ideas on how I can achieve the ability to report on all activities under this Phase abc-123.

Thanks in advance

Dave

Hi David_Horne,
I would suggest starting with checking your Issue hierarchy setup. Do you have a Issue hierarchy that correctly represents your Jira structure, including the Phase issue type and its child issues? This might be an existing one like Epic or Parent hierarchy ( Issue hierarchies) or you can define a new custom issue hierarchy (Additional Issue hierarchies )

To display only the child issues under a specific Phase, you can apply a filter in the Issue dimension within the Pages section or use specific hierarchy level dimension (in my example, I’m showing parent hierarchy Improvement level),

I hope this helps.

Kindly,
Ilze

1 Like

Thanks for this. :slight_smile: :smiley: