I am trying to create a report of all tickets that were in a sprint and moved to a new sprint. However, I haven't figured out how to do this.
One theory I have doesn't work, is to take advantage of automation for JIRA, and when a sprint value is edited to update another (hidden) and put an X in that field.
I can then build a report that shows all the tickets that have this value as marked off.
The above doesn't work well because I can't figure out how to only trigger the automation rule when the field is initially not blank and changes to any other value whether it is null or has some other value.
I am open to other theories on how I could accomplish this.
