How I can identified tickets that were at a certain point (not necessarily now) in escalated status?

[Javier Castelblanco Diaz]

Hi,

I'm in the process of analyzing tickets inside Jira Service Desk that were created on March and April, and one of the things that I consider important to analyze, is which of those were at a given moment in an escalated status, even thou currently maybe they are resolved or in another status.  

Is there a way I can identified these kinds of tickets?  

Please advice.

Javier Castelblanco

[Mohamed Benziane · Accepted solution]

Hello @Javier Castelblanco Diaz 

So if correctly understand, you want to know wich ticket was in a specific workflow status during a specific period ?

You can try this :

Status was "your status" During (startofmonth(-1),endofmonth(-1))

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

[Javier Castelblanco Diaz]

Excellent @Mohamed Benziane 

Thank you very much!