Hello everyone! I’m trying to create a measure which shows the number of the sprints a determined task was worked based on the measure “Issue Sprints”. For example, the key CAREAG-3903 should be 2 while all other should be 1.
Could you help me please?
Thanks!
Hi @Leonardo_Furone ,
Welcome to the eazyBI Community
You can use this formula to count issue sprints:
NonZero(
count(
Filter(
[Sprint].[Sprint].getMembersByKeys(
[Issue].CurrentHierarchyMember.get('Sprint IDs')
),
[Sprint].CurrentHierarchyMember.name <> "(no sprint)"
)
)
)
Or see the answer from my colleague here for another approach:
Hi @budiholi94 !
I would suggest using the Sprint scope measures to sum Sprint issues committed and Sprint issues added measures - this would give a total of Sprints for which Issues have either been committed since the start from sprint or added later during the Sprint.
[Measures].[Sprint issues committed] +
[Measures].[Sprint issues added]
This measure might be even more precise, giving also sprint that Jira (and Issue sprints measure) does not show - if the issue was part of it but was not …
best,
Gerda // support@eazybi.com