Sum of Story Points of Issues whose Planned End is lower than Sprint End Date (for current sprint)

Gabriel Alves Coelho October 2, 2023

I would like to create an user-defined measure for eazyBI that gives the sum of the story points of all issues whose Planned End Date is before the Sprint End Date. I want this to only be done in the current sprint.


This is what I tried. Not working,

Sum(
Tail(Filter(
[Measures].[Story Points created],
[Sprint].CurrentMember.Get('Status') = "Active"
AND
DateCompare([Issue].CurrentMember.Get('Planned End Date'),[Sprint].CurrentMember.Get('End Date')) < 1
)
))

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events