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?
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! ...
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