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

[Gabriel Alves Coelho]

I would like to measure the sum of the story points of all issues whose Planned End Date is before the Sprint End Date. Oh, and 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
)
))

[Sir Mārtiņš Vanags · Accepted solution]

Hi @Gabriel Alves Coelho 

Try this formula for calculated measure (select "integer" output format for this measure)

Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue story points])
AND
DateCompare([Issue].CurrentMember.Get('Planned End Date'),[Sprint].CurrentMember.Get('End Date')) < 1
),
CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Issue story points]
END
)

Martins / eazyBI support

[Gabriel Alves Coelho]

No data is appearing for me

[Gabriel Alves Coelho]

I have used the code you provided. 

[Gabriel Alves Coelho]

I changed "Planned End Date" by "Planned End" and "End Date" by "End date" and it worked.

However, I noticed that it does not account for changes in the planned end. I mean, I had an issue whose planned end preceded the sprint end date. So I changed its planned end for later and the sum didn't change.

Any idea?

[Sir Mārtiņš Vanags]

Please reach out to support@eazybi.com and provide the report definition.

https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions

Martins / eazyBI

[Benjamin]

Hi @Gabriel Alves Coelho ,

Not sure if this can be done without apps. May help to add more context to the issue. Where are you applying the syntax and where do you want to display the results? Possibly on a dashboard?

[Gabriel Alves Coelho]

I'm applying the sintax in an user-defined measure. It's for an EazyBI dashboard.

[Benjamin]

Okay. You may want to post your question in the Third party apps and integration group.

https://community.atlassian.com/t5/Apps-Integrations/ct-p/atlassian-marketplace

or contact the vendor as well

https://eazybi.com/contact?_gl=1*1gw5fp4*_ga*MjA3OTA1ODI5Ni4xNjkyOTgzMjQ4*_ga_LKTNY5C56W*MTY5NjI4ODEzMS4xLjEuMTY5NjI4ODE2OS4yMi4wLjA.