Hello,
I read this question but it didn't seem to work for me.
So for sprint 1, I have 5 issues, of those 3 are done and 2 are in progress. I end the sprint, if I run the query suggested in this question, I get good data.
Three days later in sprint 2, one of the prior in progress items goes to a done state. When I run the query again, I get the current status of done when what i want is the status of in progress.
I don't know if this is possible, but I'm down for trying in simple JIRA. I know I could export the data to Excel at the end of the sprint. Also, I don't have access to a script runner as the JIRA admin's don't want us to that type of those actions in the data center.