Create a view with Epic and thier children issues filtered on Epic components

Questions & Answers
1

I have Epics that have specific components on them E.g. Feature-Merge.
These epics have Stories and Tasks under them. However these stories and tasks have different components associated with them.
I want to show the progress on “Feature-Merge” and have a gannt chart to show the progress but when I use the “Pages” filter on Component = “Feature-Merge”, as expected it only returns the Epic since none of the stories have that component.
How do I create a view that is based on the Epic component but also returns all issues under that Epic, irrespective of what the component on the children issues is?
Thanks

2

Hi @PRL ,
​
​Since the compoent is a multi-value field - it cannot be inherited from parent issue to children and grandchildren.
​In this case, you would need to use the Ancestor() function to reach out for the Epic standing above in the hierarchy and return the result if the condition is fulfilled.
​
​Please read more about the Ancestor() function here - Ancestor.
​
​The construction might be as follows.
​

CASE WHEN
--condition to avoid error for the "All issues" level when there are no Epic ancestors
 NOT [Issue].CurrentHierarchyMember is [Issue].CurrentHierarchy.DefaultMember
--optional extra clause for condition if Initiative exists on top of Epic in this hierarchy
-- AND
-- NOT [Issue].CurrentHierarchyMember.Level.Name = "Initiative"
THEN
 CASE WHEN
--checking Epic relevance to the report context - filters etc.
  ([Measures].[Issues created],
--reach up within hierarchy
   Ancestor(
--the start point for climbing up the hierarchy
    [Issue].CurrentHierarchyMember,
--destination level for climbing up the hierarchy
    [Issue].CurrentHierarchy.Levels("Epic")),
--limit issue type to only check the Epic relevance
   [Issue Type].[Epic])>0
 THEN
  <primary calculation to be done at the individual issue level - expression to be displayed>
 END
END

Regards,
​Oskars / support@eazyBI.com​
​