It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

0 answers

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Jira Cloud for Google Sheets: Automatically Refresh Your Data!

Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...

7,372 views 33 29
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you