I have Epics that contain User Story or/and Technical Story.
An Epic that contain at least one User Story is considered as “functional” otherwise it is considered as “non-functional”.
I want to build a report with:
Issue Type (with User Story and Technical Story selected)
Issue (with Issue hierarchy level selected)
Original estimated hours with sub-tasks
And I want to build a report with only issues belonging to “functional” Epics and another one with only issues belonging to “non-functional” Epics.
What I have in mind is to create a calculated measure that counts the number of User Story under the issue’s parent Epic and then filter issues based on this calculated measure.
For another report listing Epics (Epic Link dimension), I’ve created the following calculated measure Functional Epic to filter “functional”/“non-functional” Epics:
[Issue Type].[User Story]
) > 0
What could be the equivalent formula in the context of my report listing issues?
Thanks for your support.