Fetch stories completed in closed sprints in JIRA

Question

End Result that am aiming for: Fetch stories that are done in closed sprints by a developer  (Velocity per developer)

ATM, I am using Single Level Group By Report to achieve this.

But the issue is, I see the stories being shown in a sprint even if they are not completed in that sprint but have been completed may be 2 sprints after, but I want to see only completed stories per sprint just that I can get values out of it.

Prakhar Srivastav {Appfire} · Answer

@[deleted]

Ok.

Since burndown chart is basically team oriented , I  don't think individual burndown will be available by default in jira.

One work around I can think of is create a board for each individual with your own filter (assignee == user1 and all other conditions that you need) and it will show your burndown chart.

Regards

Prakhar

unknown · Answer

I don't think it works even if I go with the approach as explained above.

For example, my current filter looks as such:

project = "XYZ" AND Sprint in openSprints() OR Sprint in closedSprints() AND issuetype in (Bug, Story, Analysis) AND assignee = "ABC"

Nevertheless, if you have 30 sprints and adjusting your query to suit the timings according to each sprint? Isn't that quite cumbersome. Even if it is done in the end, I don't really think we can achieve what is deemed to.

Isn't their any other alternative that shows number of story points burned by each developer each sprint, exactly similar to what we have for team velocity?

Prakhar Srivastav {Appfire} · Answer

Hi @[deleted]

In JIRA , you can write jql query which will do historical search. I think the problem here is that the current status of stories are Done but they may not have been completed when the actual Sprint ends (and they got complete afterwards)

You can search jql something like status was Done between dates

This page will give you complete solution of how to write these kinds of queries :

https://community.atlassian.com/t5/Jira-articles/Becoming-a-JIRA-Search-Ninja-History-searches-in-JIRA/ba-p/461943

Regards

Prakhar