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

[Deleted user]

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]

Hello @[deleted]

Indeed this sounds very much like the velocity chart report. May I ask, what gaps do you find in the currently available reports?

[Deleted user]

Hello Fernando, 

Thanks for your answer. Yes, this query is something similar to velocity chart but the gap is that I need and query In JQL due to I need historial data and this chart only displayed the last 6 sprints. 

I need this query too, because I am trying to create a dashboard in google sheets with more information and more relevant metrics and velocity chart option displayed only a chart and I need the values. 

Best regards 

Geovanny avila 

[Fernando Bordallo]

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:

1. 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
2. export CSV for historical data and create smart filters on the data in google sheets directly

What have your approaches been so far?

[Deleted user]

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]

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