Hi @Kristina,
If an issue is not resolved during an assigned sprint, then the property “Issue sprint” is cleared, but sprint scope measures will show the information of previous sprints when used with Sprint dimension.
One option is to construct the calculated measure that would go through all issues and check their history for any sprint values. But I would not recommend this solution as it is resourceful and might slow down the report.
In this case, you might want to precalculate this information with JavaScript calculated custom field and import a new dimension “Number of sprints” that groups issues by the count of sprints they have been assigned during their lifecycle. Please see this Community post where is provided the code and instructions on how to import “Number of sprints” as dimension.
Then you may add dimension “Number of sprints” on pages to your report and filter data by value (none) to get all issues that have never been in any sprint.
Best,
Zane / support@eazyBI.com