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 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
)
))

2 answers

1 accepted

1 vote
Answer accepted
Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 3, 2023

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 October 3, 2023

2023-10-03 13_22_04-Throughput Test 2 - Issues Engenheiro Chefe - Engenheiro Chefe - eazyBI.png

No data is appearing for me

Gabriel Alves Coelho October 3, 2023

I have used the code you provided. 

Gabriel Alves Coelho October 3, 2023

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?

Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2023

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

0 votes
Benjamin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 2, 2023

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 October 2, 2023

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

Benjamin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 2, 2023

Suggest an answer

Log in or Sign up to answer