Manually Compute Agile/Sprint Statistics with Raw Data

[Jerrod Omere]

I am using DOMO (a reporting tool) with 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:

• 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.

So I need to export the raw data and essentially recreate the queries the JIRA agile module produces for these functions which I don't see the source code for anywhere:

• atSprintStart (does not exist 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?

[Bob Sovers]

I started reading this and thought .. "That's just what I need!".  I was VERY disappointed that this got 0 responses.  I am trying to get to the same place as Jerrod.  Has anyone solved this problem??? 

My boss asked me to post this here to see if it is already a solved problem.  I am going to continue with what I am working on, and may be able to share it here.