Hello guys,
I’m creating a report of Sprints statistics. One of the measures of this report is “Planned Story Points”, and in this measure I need to get all Story Points at Sprint start date and show on the chart. I’ve tried to use the measure Story Points committed, but it only works when the Sprint is closed, and it doesn’t fit to my problem, I need the correct value while the Sprint is in progress. Is it possible to do this?
I was wondering if it’s possible to use the measure Story points history and bind him to a specific date like
CASE WHEN
[Measures].[Story points history] > 0
THEN
[Measures].[Story points history] = [Measures].[Story points history] – (At specific date here)
But I don’t know if this is possible, so I’ve tried to calculate those points using another measures but it doesn’t work for all sprints:
[Measures].[Story Points remaining]+
[Measures].[Cumulative Story Points resolved]-
[Measures].[Sprint Story Points change]-
[Measures].[Sprint Story Points added]+
[Measures].[Sprint Story Points not completed] +
[Measures].[Sprint Story Points removed]
If someone has a solution to this problem and could share, I would be grateful.
Thank you in advance.