How can i write query to get data based on % like - % of issues which met their SLA

[Ruchi Tyagi]

How can i write query to get data based on % like - % of issues which met their SLA or which breached their SLA

[Alana Fernando]

@Ruchi Tyagi,

I use below queries.

• "Time to Initial Ack" = breached() 
• "Resolve" = completed() 

you may change them as below 

• "<your SLA name>" = completed() 
• "<your SLA name>" = breached() 

hope this helps :) 

Reporting on SLAs with JQL

Another related Question

[Secure Meters Limited]

this query is giving just count of records. i need data in %

[Alana Fernando]

hi @Secure Meters Limited, 

this is not possible with default JIRA. 

I even tried a way to do this using Adaptive script runner plugin and i was unable to find any luck. :-(

A one hard way to achieve this is by  Adding your own JQL function to JIRA else you better post your feature request to Atlassian

If you wish to get the same results by a report. you may follow below link. there you can have the count in %

Reporting on SLAs

hope this helps :-)