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 Report and 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:

  • Team Name
  • Sprint Name
  • 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 the Sprint Report which 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 the Start column above)
  • addedAfterSprintStart (Add column above)
  • removedAfterSprintStart (Removed column above)
  • incompleteInSprint
  • completeInSprint (End 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?