I am having an issue creating calculated members for my need. I’ve tried numerous google searches and searching on the forums here.
What I am trying to build in a Sprint view
Committed AND Completed
Committed AND NOT Completed
Added AND Completed
Added AND NOT Completed
I am having issues building out how the calculated members would look for these. If someone assists with one, I may be able to manipulate to the rest.
Attached is an inspiration image I am trying to build.
Thanks!
I would love something like this as well - it’s a great way to highlight how well a team is handling what’s thrown at them!
We don’t work in Story Points - but an equivalent would be ‘Remaining Estimated Hours’
Hi,
In this case, you could create new calculated measures by combining some of the default eazyBI
measures:
https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-software-custom-fields#JiraSoftwarecustomfields-ImportedSprintsmeasuresandproperties
Try this code for “Committed and Completed”:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Sprint issues commited]>0
AND
[Measures].[Sprint issues completed]>0
)
)
)
Quite similar logic can be used to create the rest of your required calculated measures.
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Sprint issues commited]>0
AND
IsEmpty([Measures].[Sprint issues completed])
)
)
)
But that would return the count of issues.
If you expect to see the number of Story points, there are some other default measure to play with.
Best regards,
Martins / eazyBI team