I have three levels of hierarchy - Feature Link, Issue & Linked Defects. I want to generate a report to show -
- The number of Stories associated with each Feature
- The number of Defects and Test Cases associated with each Story and then roll up to Feature
- Calculate the average Fix, Retest & Closure duration of for each Story and then roll up to Feature. I have the Fix, Retest & Closure duration for each Defect.
#1 is working at both Feature Link and Issue levels using the below calculated measure.
CASE
WHEN
[Linked Defects].CurrentMember.Level.Name = “Linked Defects”
THEN
‘’
WHEN
[Issue].CurrentMember.Level.Name = “Issue”
THEN
1
ELSE
CoalesceEmpty(
(
[Measures].[Issues created],
[Issue Type].[Story]
),
0
)
END
#2 is working at Issue level (Story). However, it is NOT working at Feature Link level. I am using the below calculated measure.
CASE
WHEN
[Linked Defects].CurrentMember.Level.Name = “Linked Defects”
THEN
‘’
WHEN
[Issue].CurrentMember.Level.Name = “Issue”
THEN
CoalesceEmpty(
Nonzero(
Count(
[Issue].CurrentHierarchy.GetLinkedMembers(‘Linked Defects’)
)
),
0
)
ELSE
CoalesceEmpty(
SUM(
Descendants([Feature Link].CurrentMember,[Feature Link].[Epic]),
Count([Issue].CurrentHierarchy.GetLinkedMembers(‘Linked Defects’))
),
‘abc’
)
END
#3 I haven’t been able to try.
I have referred the issue links and hierarchies reports, but those refer to only two levels. I need help with three levels.
Below is screenshot of the report.
Thanks,
Ranjan