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
)
))
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please reach out to support@eazybi.com and provide the report definition.
Martins / eazyBI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm applying the sintax in an user-defined measure. It's for an EazyBI dashboard.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.