Report to show count of stories assigned to a team vs the number of stories we completed in sprint.

[Dee S]

Hi,

I've a requirement to create a report that shows over a period of time the number of new stories assigned to a team vs the number of stories we completed that same sprint.

The story can be created anytime, say - story created by requestor some time back when requirement was discussed but refined and assigned to the team in this sprint.

So, the report should show the count of stories assigned in this sprint vs the count of stories completed in this sprint.

For stories assigned to team, I cannot consider stories created in this month (particular time) as above mentioned story can be created at any time.

Need help in taking the count of incidents assigned in this month.

[Mark Manders · Accepted solution]

You can create a bar chart on the story table, with a 'group by' on assignment group. Then create another dataset for the same report on the story table, grouped by assignment group, but with the condition 'state is completed'. It will show like below.

Depending on your filtering (you could use a default filter if you have something like 'current' on your sprint), you can put the report on a dashboard and put an interactive filter to the sprint on it. You can select the sprint and it will show you everything within that sprint.

[Dee S]

@Mark Manders - Thank you!