Sprint Report shows a spike at the beginning of the Sprint in Jira


アトラシアン コミュニティをご利用ください。


プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。



Sprint Report shows an increase in workload at the beginning of the Sprint as if stories were added after the Sprint has started.

Example report:


All versions of Jira Software 7.x and 8.x.


Check the Sprint Report for issues that have an asterisk. They're been added after the Sprint Start Date.

The query below will show (in epoch time) when the Sprint "OPEN" operation was performed and which dates were entered as Sprint Start and Sprint End dates:

Query 1) Sprint data
select s."ID", s."NAME", s."RAPID_VIEW_ID", ae."DATA", ae."TIME", s."START_DATE", s."END_DATE"
from "AO_60DB71_SPRINT" s
join "AO_60DB71_AUDITENTRY" ae on ae."ENTITY_ID" = s."ID"
where s."NAME" = '<SPRINT NAME>';

The query below will show which stories were once included in the Sprint and when (created column):

Query 2) Stories data
select p.pkey, i.issuenum, i.id, au.lower_user_name, cg.created, ci.field, ci.oldvalue, ci.newvalue, ci.oldstring, ci.newstring
from changeitem ci
join changegroup cg on cg.id = ci.groupid
join jiraissue i on i.id = cg.issueid
join project p on p.id = i.project
join app_user au on au.user_key = cg.author
where ci.field in ('Story Points', 'Sprint')
and i.id in (select issueid from changeitem, changegroup where newstring = '<SPRINT NAME>' and changeitem.groupid = changegroup.id)
order by created, id;

Replace SPRINT NAME on the commands above with the corresponding Sprint name.

The queries above are examples and built for Postgres and may need to be adjusted to your database type.


The Sprint report spikes for every Story added after the Sprint Start Date — not the Sprint start operation date (when the start button was pressed).

For the query #1 above, all stories added to the sprint after the "START_DATE" will count as a Story added after the Sprint was started — even if the start button was pressed after all stories have been added to the Sprint.


The most appropriate approach is to edit (may have to reopen) the Sprint and adjust the Start Date to some time after all stories were added to the Sprint (query #2 on the Diagnosis section above). Luckily, this would mean postponing the Sprint Start Date only a few hours instead of days.

Last modified on Mar 10, 2021


Powered by Confluence and Scroll Viewport.