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

Question

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

Alana Fernando · Answer

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 :-)

Secure Meters Limited · Answer

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

Alana Fernando · Answer

@Ruchi Tyagi, I use below queries. * "Time to Initial Ack" = breached() * "Resolve" = completed() you may change them as below * "" = completed() * "" = breached() hope this helps :) Reporting on SLAs with JQL Another related Question