How can I do a JQL query with the field completed story points and estimated story points by sprint

Question

Hello Jira Community

I have been tried to do a Query with JQL in order to calculate all the meet of the sprint by story points respect to the estimated story point (Something similar to Velocity chart) but it has not been possible.

The query I need is the following:

Example:

Sprint, estimated story points, completed story points

Sprint 1,  45 , 30

Sprint 2, 50, 25

Sprint 3, 45, 45

This is very important because I need to know the performance of the projects.

Fernando Bordallo · Answer

Hello @[deleted]

I think these two threads can be followed in parallel:

https://community.atlassian.com/t5/Jira-Software-questions/How-can-I-identify-the-sprint-where-a-issue-was-completed-in-JQL/qaq-p/1267667?utm_source=atlcomm&utm_medium=email&utm_campaign=immediate_general_reply&utm_content=topic#U1275157

I've left a comment in the other thread on the matter

unknown · Answer

Hello Fernando, How are you?

I think, this proposal It is not enough. The real problem is that I can not identify in the number of story points estimated by sprint and the number of completed story points by sprints.

If this is possible, you would be able to send me an example of the JQL query?

Thanks and I will be looking forward  your answere.

Geovanny

Fernando Bordallo · Answer

Hello again @[deleted]

I see. That being the case I would recommend that you do the "heavy lifting" outside Jira. Two ways I can imagine I'd deal with this scenario:

* create a script to send JQL queries to the REST API, requesting the issue information based on date ranges. Then export to CSV and manage in google sheets
* export CSV for historical data and create smart filters on the data in google sheets directly

What have your approaches been so far?