I would like to see a list of the latest status changes across all tickets in my project.
For example:
Ticket | From | To | Date
TCK-1 | ToDo | Done | 2022-12-06 09:32
TCK-2 | New | ToDo | 2022-12-06 09:40
How can I generate such a report?
In general I'd like to find tickets that were moved from New into ToDo and then back to New, so this table would allow me to find all the tickets that were moved back in the statuses and see if it was a quick fix to an accidental status change, or was it something done after a longer period of time.