how to get completed items in the sprint but without showing carried over tickets?

[Daniela Cancino]

I'm trying to generate a JQL query to get the amount of story points based on completed sprints but I'm getting duplicated story points over the sprints as sometimes the tickets are carried over to other sprints.

The JQL query used is:

project = "POL" AND sprint IN (2, 75, 110, 344, 744, 876, 1008) ORDER BY createdDate DESC

[Bill Sheboy]

Hi @Daniela Cancino -- Welcome to the Atlassian Community!

That is not possible with the built-in features of JQL.

Some workarounds depend upon how often you want to perform this type of query and your cost / effort constraints:

• need this one time
  • manually review the built-in sprint reports and record the sums
  • export the issues to a spreadsheet, use formulas to detect the last sprint, and pivot on the results to sum the values
• need this often
  • have money to spend
    • investigate marketplace apps which add features to JQL
    • investigate marketplace apps which add reporting to handle this case
  • do not have money to spend, and willing to build something
    • create an automation rule, triggered on Sprint Completed, which saves the sprint in a custom field, such as "Completed In Sprint", and then use built-in JQL to check that field and sum the values
    • create a stand-alone application using the REST API endpoints to perform this type of reporting

Kind regards,
Bill