Need to get data -“No of issue whose resolved time duration was between 45m (from open-close)

[Ruchi Tyagi]

Need top get data--No of issue whose resolved time duration was between 45m (from open-close).

i have defined SLA of 45 min. need the count of records which completed their open to resolved cycle with in 45 min.

help me to define this query

[Secure Meters Limited]

It didnt work..

Let me elaborate my query.

I have defined SLA goal as 45 min for particular issue type.

Now i want to search data--- How many tickets were resolved within its defined SLA goal (45m) means their open to resolve cycle took time less than 45m.

In same pattern i want data---How many tickets were resolved within 2hours

means their open to resolve cycle took time within 2 hours. Please note now this query should contain earlier query result too (resolved with 45m+ resolved between 2hrs)

Please guid.

How to write this type of queries in JQL advanced filter.

[Alana Fernando]

@Secure Meters Limited,

1. to filter tickets that meet its SLA goal "<your SLA name>"  != breached()  (example: "Time to Initial Ack" != breached()) can be use 
2. to filter tickets that resolved within 2 hours status changed from "Open" to ("Resolved", "Closed") AFTER -2h can be use 

combining above 2 queries "<your SLA name>"  != breached() and status changed from "Open" to ("Resolved", "Closed") AFTER -2h gives you tickets that meet their SLA which is 25 minutes and resolved withing last 2 hours 

does this work for you? 

if you are looking for tickets that took 2 hour to resolve you can use below JQL

"<your SLA name>" = elapsed("2h")

[Alana Fernando]

@Ruchi Tyagi,

I use below JQL 

"Time to Initial Ack" = completed() 

you may customize it as below

"<your SLA name>" = completed() 

Reference:

• https://coresoftlabs.atlassian.net/wiki/spaces/SP/pages/9306152/Reporting+on+SLAs+with+JQL
• https://community.atlassian.com/t5/Questions/SLA-PowerBox-JQL-Searching-for-breached-issues/qaq-p/254497

[Secure Meters Limited]

its not given correct data.

[Alana Fernando]

hi @Ruchi Tyagi,

try below query as well. if it doesn't work for you , please elaborate your requirement more to understand your requirement :-)

resolutiondate <= -45m AND status = Closed