Want to create JIRA report in EazyBI

I have a report in JIRA on SLA for incidents where I keep all the issues accordingly there SLA

  1. SLA Breached
  2. 50% SLA
  3. Not Breached

I used following syntax in Jira

  1. 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”

  2. 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”

  3. 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 :wink: ) I can’t seem to get this in EazyBI.

Hi @_P3,
Welcome to the eazyBI community! :wave:

eazyBI is a non-real-time data analysis app and that means we don’t have the option to see in real-time when the issues are elapsed within SLA calendar as it can be done in Jira by using filter elapsed().

About Jira Service Desk integration and possibilities you can see more in here - https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-service-desk-custom-fields. As well as in our demo account - https://eazybi.com/accounts/1001/dashboards/7128-sla-dashboard