Hi,
I would like to represent the ability of the team to focus on as little epics as possible during a sprint.
To achieve that I would like to count the distinct epics of stories which are in a given sprint.
Everything I tried so far didn‘t result in the desired behaviour - so I am hoping someone here can help me and point me to the right direction.
Kr
I played around a bit and wanted to start with counting Epics in the sprint
CASE WHEN [Issue].[Issue].CurrentHierarchyMember.Level.Name <> 'Issue'
THEN
NonZero(Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issue Epic Link] <> ""
)
))
END
however this seems to disregard the sprint in the row and count all epics
Can anyone point me towards how to make sure my calculated measure is restricted to the sprint in the row?
kr
@Lokilicious
Try using a simple tuple construction in your formula:
(
[Measures].[Issues created],
[Issue type].[Epic]
)
That should count issues with issue type Epic for each Sprint.
Martins / eazyBI
@martins.vanags Thanks, but as far as i understood your tuple is only looking at epics which were created - i am interested in any epics which have stories inside the sprint.
I already tried around a bit and am now at a stage where i limit the view to Epics - the only thing not working right now is counting it up correctly. (for some reason it counts up to 415 instead of 2)
Thats how it looks:
and thats the formula:
NonZero(Count(
Filter(Descendants([Issue.Epic].CurrentHierarchyMember,
[Issue.Epic].[Epic]),
[Issue.Epic].CurrentHierarchyMember.Name <> '(no epic)'
)
))
any idea what to change to make it work?
Your observation is correct.
Try this formula:
Sum(
Filter(Descendants([Issue.Epic].CurrentMember,
[Issue.Epic].[Epic]),
[Issue.Epic].CurrentHierarchyMember.Name <> '(no epic)'
),
CASE WHEN
([Measures].[Issues created],[Issue type].[Story])>0
THEN
1
END
)
Martins
