JIRA REST API Connector to Calculate JIRA Agile / JIRA Sprint Statistics
I'm using the JIRA REST API cloud connector to connect to JIRA cloud. I am pulling in all of the raw data using the Standard Ticket Reportand Ticket History Report and joining the two datasets together by ticket ID to get the change history for each ticket. I need to calculate the following metrics for each sprint and these would be the columns:
Sprint Start Date
Sprint End Date
Start= story points allocated when the sprint started in JIRA
Add= story points added after sprint start
Removed= story points removed after sprint start
End= story points in a status of resolved and/or done when the sprint has closed in JIRA
I'm unable to use theSprint Reportwhich does appear to have what I need because it requires a board ID and sprint ID because I need to show a 3,6,12 month view across all teams or a specific team (they will be able to filter on time range or team).
So I need to export the raw data and essentially recreate the queries the JIRA agile module (Greenhopper?) produces for these functions below which I don't see the source code for anywhere:
atSprintStart()(does not exist today but need it for theStart column above)
So essentially what fields should I specifically be looking at from the Standard Ticket Report and Ticket History Report to recreate the output of these (seemingly proprietary) functions to produce the dataset with the columns mentioned above?