I am looking for a way to report active user stories for more than a sprint. We practice sprint planning by selecting groomed user stories from the product backlog into sprint backlog and aim to complete those during the sprint. Sometimes, the team picks up user stories and keeps them active for more than a sprint, which is not our practice. How do we report such user stories? The logic I am looking for is from the first sprint; a user story is active to the last sprint; it is in the active state. I looked at the lead time and cycle time charts, but they did not provide specific insight into for above scenario.
Ideally, we would like a user story completed within a single sprint (Col 2). However, sometimes we have a user story span across multiple sprints (Col 3 or Col 4). My question would be, how do I report such User Stories? Unfortunately, we have many teams, and it is not possible to review every team's work items.