I need to create areport that showing chart for no features that missing child

Questions & Answers
1

I have this hierarchy: Featre ,Epic, story , sub-story. I need to list how many features that missing epic as child

so

Project: No of ticket missing childs
A. 50
B 60

then I can create bar chart from it knowing there are others validations display in the same chart

2

Hi Hala,

To achieve this in eazyBI, you’ll first need to define your issue hierarchy (Feature → Epic) as a custom hierarchy → eazyBI – Plans Custom Fields for Jira Cloud

Once your hierarchy is in place, you can use a calculated measure like this to count the number of Features that have no Epics as children:

Count(
  Filter(
    Descendants([Issue.Parent].CurrentHierarchyMember, [Issue.Parent].[Hierarchy Level 4]),
    (
      [Measures].[Issues created],
      [Issue Type].[Epic]
    ) = 0
  )
)

Note that in [Hierarchy Level 4] , you should use the name corresponding to the level of Feature in your hierarchy.

This MDX expression filters Features that don’t a child Epic, and then counts them. If you’re looking for Features with Epics, just adjust the condition to > 0.

3

I am not an admin, but I am unsure if this is already set up on advanced settings or not for all accounts . but this is the review of the issue . and the parent link is also having values . and I am using issue as adimesnion with type feature . what should I do as steps if you can help me more

1 Like
4

Hi Hala,

It looks like the hierarchy is already set up correctly, which is great.

You can go ahead and create the following custom measure to count the number of Features that do not have any Epic as a child:

Count(
  Filter(
    Descendants([Issue.Parent].CurrentHierarchyMember, [Issue.Parent].[Feature]),
    IsEmpty((
      [Measures].[Issues created],
      [Issue Type].[Epic]
    ) )
  )
)

This will filter the hierarchy and count only those Features where no child Epic exists.

5

not sure why I have these measures as 0 for all issues. I have put this as rows and selected the total tickets from individual members, which contain all tickets. and I put this measure as column

Image 5-26-25 at 11.01 PM
Image 5-26-25 at 11.01 PM546×1138 103 KB

6

Hi Hala,
Make sure you create this Calculated Measure in the Measures Dimension, and it should work:)
Also, if you would like to see the issues when clicking ‘Drill Through’, then you would need to select in the Issue Dimension the ‘All Issues’ in the parent Hierarchy

7

Hi @Hala_Eltranisy

The code @Amit_Shil shared has to be used for creating new user-defined calculated measure - not the calculated member in “Issue” dimension.

But I believe you would need a little bit different code for your calculated measure:

SUM(
  Filter(
    Descendants([Issue.Parent].CurrentHierarchyMember, [Issue.Parent].[Feature]),
      IsEmpty(Sum(
          ChildrenSet(
            [Issue.Parent].CurrentMember
          ),
          (
            [Measures].[Issues created],
            [Issue Type].[Epic],
            [Project].CurrentHierarchy.DefaultMember,
            [Time].CurrentHierarchy.DefaultMember
          )
      ))
    ),
    CASE WHEN [Measures].[Issues created] > 0
    THEN
    1
    END
)

Also, we do not recommend renaming default member “All Issues” to any other custom name for the “Issue” dimension default hierarchy

Martins // eazyBI support

P.s. Thank you @Amit_Shil for your help on this thread.

image
image478×1000 81.2 KB

image
image2194×1330 246 KB