Trying to build a PIE chart that only displays issues that are in a set of sprints, provided that they have been moved into at least 1 of the selected sprints before a specific date.
The intent is to baseline total points created to help highlight what was committed before the start of a program increment (in this case, the specific date is the start date of the 1st sprint of a 5 sprint PI).
Once built, the report would be used at a moment in time capture of the Program Increment’s baseline in order to compare against actuals throughout the course of the PI.
Is there a way to do this?
eazyBI imports historical information about sprint changes for issues. While we have default measures to analyse scope of a sprint (since committed till completed). You can define more measures for other use cases.
You can use a tuple with measure Story Points history and date member representing the date you are looking for:
([Measures].[Story Points history], [Time].CurrentHierarchy.Levels(“Day”).DateMember( ‘01 JAN 2020’ ), [Sprint Status].[Future])
Here is how it looks in report. I planned my D1 Board for several upcoming sprints on that date:
If necessary, you can define some dynamic way on how to point to a particular date there.
Let me know if you have any questions about this.