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

Question

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)

Miriam Hopton_5ys00z · Answer

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

Jobin Kuruvilla [Adaptavist] · Answer

Try this:

status changed TO Escalated BEFORE date AFTER date

Date can be hard coded dates or relative dates