Hi! I have created a report where it shows the time where the user commits to deliver a ticket until it is resolved.
And the commitment point will be either when the Sprint started or when the issue was added during Sprint. And as it could be that an issue is a spillover from one Sprint to another, we should check the 1st Sprint to obtain that date.
For that I created the commitment date like:
1st question, is the formula to obtain the committed correctly created?
CASE WHEN
Count(
[Sprint].[Sprint].getMembersByKeys(
[Issue].CurrentHierarchyMember.get('Sprint IDs')
)
) = 1
THEN
Iif(
[Measures].[Issue Sprint Incoming State] = 'Added',
-- Added in the middle of the Sprint
TimestampToDate(
(
[Measures].[Transition to first timestamp],
[Transition Field].[Sprint]
)
)
-- It was planned during Sprint Planning:
(
(
[Measures].[Transition to first timestamp],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
[Issue Sprint Status Change].[(none) => Active],
[Time].DefaultMember
)
)
)
ELSE
[Sprint].[Sprint].GetMembersByKeys(
[Issue].CurrentHierarchyMember.Get('Sprint IDs')
).Item(0).Get('Activated date')
END
And Based on the hidden property Issue Sprint Incoming State:
I found this for some tickets these properties in the report:
- Sprint: (no sprint)
- Sprint ID: -1
- Sprint IDs: 106539
- Sprint Status: (none)
- Sprint Incoming State: (none)
When in my Sprint report I found that issue was added during the Sprint Planning (no asterisk nearby the issue) and it was in resolved status (no final).
2nd question
Why does it have that “none” as Sprint Incoming State? How should I threat these kind of cases?
