When you edit an issue then you have two fields "Sprint" (can only be one) and "Completed Sprints" (which is a list). But when you make a filter you only have "Sprint" (which is a combined list of both fields). Now this leads to a problem in a "Two Dimensional Filter Statistics" report I would like to solve.
When I make a filter like so:
Sprint is not EMPTY AND Sprint in (openSprints(), futureSprints()) ORDER BY Sprint, Priority
And when I have the Sprint on the x or y axis then I get all the past completed sprints which I do not want.
On the other hand when I make the query like this:
Sprint is not EMPTY AND Sprint not in (closedSprints()) ORDER BY Sprint, Priority
then I loose all the Issues having a single completed sprint regardless if there is also an active one or not. I have also tried to find a plugin without much success. Is there a way I can access only the "Sprint" field without any "Completed Sprint"?