Issues added after sprint start

[Margarita Artemyan]

Hi Everyone, 

I am downloading Better excel after every sprint end to prepare the sprint metrics for the team, and I can't find a way how to identify tickets added in the sprint after the start date in the Excel.  Is there any way out there to understand the scope change? 

In Jira I use the JQL issueFunction in addedAfterSprintStart(Board id, sprint id) and in this way I see the added tickets, but I am looking for a way to download the excel of the whole sprint and identify there how many stories/hours are added or descoped. 

[stephanie_hart]

I do not have the "addedAfterSprintStart" function, does someone have another query to do this i can use?

[Kishan Sharma]

Hi @Margarita Artemyan 

Please try below to download issues from a specific sprint -

1. Switch to Reports> Sprint Report.
2. Select desired Sprint.
3. Select the option "View in Issue Navigator".
4. Use "Export" to CSV option.

[Margarita Artemyan]

Thanks @Kishan Sharma , when exporting i cant see in the csv which tickets were added after sprint start date. 

[Kishan Sharma]

Yes the report will only give you all the issues that are included in the sprint. You mentioned you use JQL issueFunction in addedAfterSprintStart(Board id, sprint id)- so you can export the results of that JQL in csv and then do VLOOKUP in excel to know which issues were added after the sprint start date. I know a bit of manual work here, but it gives you the result you want.