Where do we find sprint start date

[BSpangenberg]

I'm looking through the schema and in the jsw-sprint table I am seeing complete_at but am not seeing the corresponding start_at.  Where do we find the actual sprint start date?

[Inder Singh · Accepted solution]

@BSpangenberg : You have to get that information from "Projected to start at" column in Sprint table 

Thanks,

Inder

[BSpangenberg]

it looks like the projected start date gets updated to be the actual start date after the sprint starts? Same idea for the projected end date?

[Inder Singh]

@BSpangenberg : Correct. In addition, "Completed at" is the date and time (UTC time zone) when the sprint’s status changed to closed, which signifies the sprint was completed (https://support.atlassian.com/analytics/docs/schema-for-jira-software/#Table-for-sprint-data) .

Thanks,

Inder

PS: You can also download and see the queries in 2 sprint templates that are available (Single sprint overview and Multiple sprint overview) to see how some of these metrics are computed.