Hello,
Looking at the built in report --> Sprint Report, identifies three scenarios for the stories associated w/ the sprint (completed, not completed, and removed). All three are very helpful. What I'd like to do is write a query/queries that can identify the three scenarios to use for additional reporting via Excel/PowerBI.
I am primarily interested in how to query for items that were at one time assigned to a sprint, removed (i.e. returned to backlog) and not just transitioned to the next sprint, which leaves the 'Sprint' field of the item as blank/None.
What is the Sprint Report looking at for items that at one time were assigned to a sprint and then removed?
Thanks in advance!
~Ian