Hello, we are looking to do a report that shows issues which, at the start of the sprint, had a story point value of null but then were given story points during the sprint.
I know that you can report on a change of story points within a sprint, but we want to identify the issues that were there and started with a story point value of null/empty.
In this case, you would like to check several activities for each issue - if it was committed in a sprint and if there was no story points or 0 story points at the time of commitment. Then you also should check if there were any points added during the sprint as well.
Here is an example formula for this:
CASE WHEN
[Sprint].Currentmember.Level.name = "Sprint"
THEN
NonZero(SUM(
-- filters possible issue set in Sprint using properties only
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
DateCompare(
[Issue].CurrentHierarchyMember.Get('Created at'),
[Sprint].CurrentMember.Get('End date')) <= 0
AND
(isEmpty( [Issue].CurrentHierarchyMember.Get('Resolved at'))
or
DateCompare(
[Issue].CurrentHierarchyMember.Get('Resolved at'),
[Sprint].CurrentMember.Get('Start date')) > 0)
),
CASE WHEN
-- filters by activity in sprint: committed with no Story Points that were added later.
[Measures].[Sprint issues committed] > 0
AND
CoalesceEmpty([Measures].[Sprint Story Points committed],0) = 0
AND
[Measures].[Sprint Story Points change] > 0
THEN
[Measures].[Sprint issues committed]
END
))
END