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)

[Tyler Brown · Accepted solution]

Hey Bella,

You should be able to use:

status changed from *STATUS* to Escalated during (yyyy-mm-dd, yyyy-mm-dd)

The first date should be the start of your desired time window and the second the end.

Hope this helps,

Tyler

[Bell Lopez]

@Tyler Brown thank you!