Best way to look at sprint items over the past quarter? Items completed/items not completed.

[Bell Lopez]

Hello everyone,

I'm trying to create a report for a couple different Jira boards where we can compare all items added to any sprint and were completed in a given quarter and also all of the items added to sprints in that quarter that were NOT completed.

The only solution that comes close to what I am trying to accomplish is by creating a sql filter where I look at all items in a project that were part of a sprint that has since been closed in the past 90 days:

project = "project name here" AND sprint in closedSprints() AND resolved > -90d

But I can't seem to figure out a good way to survey all of the sprints in the past 90 days to see what items were added but not completed during that time frame.

Does anyone have any suggestions?