I want to run a report that will be run every day that tells me which tickets went from 1) To Do to In Progress and 2) In Progress to In Review the day before, but will sort them by who the assignee was during the In Progress status.
I don't know of a specific report to do this, but you can get this information via JQL:
status changed from "To Do" to "In Progress" on -1d AND status changed from "In Progress" to "In Review" on -1d ORDER BY assignee ASC
This query returns all issues which changed from To Do, In Progress, and In Review all in the same day. I can't tell if that's exactly what you need or if you need two separate lists, but hopefully this can get you started, at least.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG