JQL Query to Show How Many Tickets Transitioned to "Escalated" Status

[Bell Lopez]

Hello,

Does anyone have any ideas about how to create a JQL query to show all tickets that have been transitioned from a certain status within a certain timeframe? Not sure what JQL parameter to use for specifying a specific timeframe the transition happened in.

For example, we have this right now for seeing if any ticket was transitioned to an "Escalated" status but how could it be modified to specify within the last year or the past month?

(status = escalated OR status was escalated)

[Jobin Kuruvilla [Adaptavist]]

Try this:

status changed TO Escalated BEFORE date AFTER date

 Date can be hard coded dates or relative dates

[Miriam Hopton]

This helped me so much! THANK YOU!!!! It gave great visibility to tickets in that status.