What is a correct query for ticket Status changed during time frame from "x" to "y"

[Vadim Gumarov]

Hi, I have a task to create a query and set up a dashboard. What is needed is the status of tickets for past week (in dashboard that would be multiple Gadgets with time frames  - so (-7d) would not work as it will be updating dashboard for only last week and exact dates needed).

The status changed should include:

1. From Open To Resolved

2. From Resolved To Closed

3. From Resolved To Reopened 

4. New tickets Opened