Data missing from the end of sprint report in Jira

[Clifford Perea]

I am noticing when I open up the end of sprint reports and it's been a few weeks, since a sprint has closed, some data is missing. Example, I opened up an end of sprint report for a sprint that closed 4 weeks ago, and the completed story tickets are no longer showing up in the end of sprint report, but they were there when the sprint closed. Can someone please shed some light on this for me? Thanks

[Ankit Srivastava]

Hi @Clifford Perea 

Hope you are doing well.. 

The Sprint Report is board-specific, so it only shows issues that currently match the board's saved filter. If the board filter has changed, or if the completed issues no longer match that filter, they may no longer appear in the report even though they were visible when the sprint closed.

Could you please check the below pointers:

• Board filter has been updated since the sprint was completed?

• Have completed issues been moved to another project or had any field changes that would cause them to no longer match the board filter?

• Are all users seeing the same behavior, or is it specific to your account?

If everything looks fine then could you share the below details:

• A screenshot of the Sprint Report showing the missing completed issues.

• The board filter (JQL) used by the board.

Thanks,

[Clifford Perea]

Hello @Ankit Srivastava thank you for your quick response and yes, I am doing well and hope the same for you!

I have looked over the first 3 bullets you listed, and everything looks good, so I am attaching a screen shot of the report showing no closed Jira tickets and the filter of the scrum board.

It won't let me add the filter in JQL format 

[Ankit Srivastava]

Thank you for sharing the screenshot.

One thing that came to mind is the board's column configuration. Could you check whether the workflow status used by your completed stories is still mapped to the rightmost (Done) column on the board?

The Sprint Report uses the board's column mapping to determine completed work. If the completed status is no longer mapped to the rightmost column, it could explain why those completed stories are no longer appearing in the report.

You can verify this by going to Board settings → Columns and checking where the workflow status for those completed issues is mapped.

If everything looks correct, please let us know, and we'll continue investigating.

[Clifford Perea]

Hello @Ankit Srivastava checked the columns and yes the "Done" status is in the correct column. Thanks

[Ankit Srivastava]

Ok.. could you please share the screenshot of the board filter, as below screenshot:

also also share the check - the completed story is still the part of that closed sprint - 

project = ABC and Sprint = "Your closed sprint" and status = Done

This will help to understand - that the closed workitems are still the part of that closed sprint.

Thanks

[Clifford Perea]

Hi @Ankit Srivastava here's the screen shot

[Ankit Srivastava]

Hi @Clifford Perea 

Please use the below JQL query to search for all available stories that are in Done status and still associated with a closed sprint.

You can run this query using the Issue Navigator Search Work Items:

project in (10031) and status = done and Sprint = "closed sprint"

Note: For Sprint = "closed sprint", please replace it with the relevant closed sprint ID or sprint name from your project.

After running the query, please review the results and verify whether they match the filter conditions configured for your board (for example, Assignee, Labels).

You can validate the stories against these filter criteria to confirm that they are correctly reflected on the board and in the associated reports.

If everything looks correct, please let us know so that we can continue with further investigation.

[Clifford Perea]

Hi @Ankit Srivastava I actually did this earlier today when I was first notified from one of my scrum masters that this issue was existing. So, I was able to confirm that when I do a separate filter to search for completed stories that they are complete and I walked through the data with my scrum master and she was also able to confirm. 

I have never seen this issue before and the filters I have on the scrum boards have been there for a few years now and nothing has been changed. 

[Clifford Perea]

Hi @Ankit Srivastava what is also very strange is that I am not seeing this issue with the last 2 sprints that have been closed. This is only an issue with the sprints closed before the last 2 and nothing has changed. 

[Clifford Perea]

Hi @Ankit Srivastava I have figured out the issue. It was a status that I had made a change on within the story workflow, so I changed the status to match other workflows for other projects, and the completed stories now show up in the end of sprint reports. Thank you for all your help!