I want to create a query that shows all of the stories in a sprint on the day the sprint begins. I noticed that the built-in Velocity widget has a 'planned' bar, but I'm not entirely sure how that's calculated.
Note that some of the stories were created before the first day of the sprint, so CreateDate won't work.
Thanks!
Check the documentation below:
https://docs.microsoft.com/en-us/azure/devops/report/dashboards/team-velocity?view=azure-devops
Planned - calculated based on the amount of work assigned to the sprint prior to the start of the sprint. This count includes work that was moved to a different sprint after the start of the sprint, but doesn't include work that was added later after the sprint started.
If you changed the status of the work item on the day the sprint begins, you may try State Change Date to see whether it works for you.
