How to get the days taken to resolve a defect via JIRA query

[Deleted user]

Please advise how to get the number of days taken to resolve the closed defects via JIRA query.

Problem I am trying to solve: I have been asked to get the number of Out Of SLA defects closed by my team since August 1, 2018. A defect is Out Of SLA if it is a P0 and open for > 2 days or P1 and open for > 7 days.

For current Out Of SLA defects, I am using the following filter in the query, but I guess created < =-2d will only provide from today, not from the time it was open? I guess doing something like (resolved-created <= 2d) could help?

AND status in (Closed) AND Environments in (Prod, PROD, Production) AND (priority = "P0: Immediate" AND created <= -2d OR priority = "P1: High" AND createdDate <= -7d OR priority = "P2: Medium")