Need to count grandchildren

Simple question. I have this structure
Initiative > epic > story

I want to return the qty of stories for each initiative
How do I do that?

Still researching whilst I wait for a hopefully quick reply.
-joe

anyone out there? This question has been sitting for a while now. I could really use help.
-joe

Hi,

The recommended solution for this use case is to implement a custom hierarchy.
Please, check the documentation and an example of how to build a hierarchy with one level above epics:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/additional-issue-hierarchies#AdditionalIssuehierarchies-HierarchywithepicsandFeatures

Once you have such hierarchy, you can add the Initiative level to the report and count stories under the initiative with the formula:

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

Kindly,
Janis, eazyBI support