I have a report in JIRA on SLA for incidents where I keep all the issues accordingly there SLA
- SLA Breached
- 50% SLA
- Not Breached
I used following syntax in Jira
-
project = WSD AND (issuetype = Incident AND priority in (“Medium (P3)”, “Laag (P4)”) AND “Time to resolution” > elapsed(80h) OR priority = “Hoog (P2)” AND “Time to resolution” > elapsed(20h) OR (priority = “Kritiek (P1)” AND “Time to resolution” > elapsed(8h))) ORDER BY key DESC, “Time to resolution”
-
project = WSD AND (issuetype = Incident AND priority in (“Medium (P3)”, “Laag (P4)”) AND “Time to resolution” > elapsed(40h) AND “Time to resolution” < elapsed(80h) OR priority = “Hoog (P2)” AND “Time to resolution” > elapsed(10h) AND “Time to resolution” < elapsed(21h) OR (priority = “Kritiek (P1)” AND “Time to resolution” > elapsed(4h) AND “Time to resolution” < elapsed(8h))) ORDER BY key DESC, “Time to resolution”
-
project = WSD AND issuetype = Incident AND status not in (closed, resolved, “Ready for ProductionRelease”, Tested, “In development”) AND (priority in (“Medium (P3)”, “Laag (P4)”) AND “Time to resolution” <= elapsed(40h)) OR (priority = “Hoog (P2)” AND “Time to resolution” <= elapsed(20h))
For some reason (probably a PICNIC problem ) I can’t seem to get this in EazyBI.