Connector Improvement: Jira Connector - Actual Sprint Start Date
CompletedIn order to produce a proper burndown chart, we need the actual Sprint start date / time, not the scheduled sprint start date. In Jira, when you create a sprint, you enter a start and end date and time which currently is being provided by FiveTran. However, we need to know the date / time that the user actually clicks the start sprint button as we want to ensure our burndown properly reflects the number of issues and size of issues when the sprint began as there is often some last minute shuffling of issues in the hours before the sprint starts, especially when a prior sprint did not complete 100% successfully. Jira does track these timestamps and uses them for their own burndown charts, which can't be accurately reproduced without this data. The actual sprint start date is most important to us, but there is an actual date/time that the user closed or ended the sprint as well which should be included for consistency.
-
Official comment
Hi Ben - Thanks for submitting this request! This is a very interesting use case. I don't think this should be too difficult for us to implement. I will add it to our backlog and discuss it with our engineering team.
Thanks,
Erin -
Ben, I'm trying to build the same kind of report in Looker but have not been able to do so using the current model. Are you using Looker for this or another BI tool?
Thanks,
Robert
-
Hi Ben -
At this time Atlassian doesn't support the `activated_date` in their REST API (See Docs). However the `start_date` field gets overwritten with the actual sprint start date when a user clicks the start sprint button in the Jira UI.
We also have recently updated our logic for capturing changes to the sprint endpoint using webhooks, so this field should be accurately updated when a sprint actually begins.
Best,
Erin -
Cross Posting from here, which had a duplicated request.
--
Hi all - This has been implemented.
You can review the release notes for this in our change log.
Best,
Erin
Please sign in to leave a comment.
Comments
4 comments