Filter query for cummulative time in status

[Gareth Bristow]

I'm trying to run SLA reports, and I require a way to report on issues which have been in, for example, "Status 1, Status 2" > 2d. This needs to be cummulative, as the statuses change frequently as issues are moved between departments. I'm trying to drill down and find the bottlenecks.

Is there any way to do this with filter queries? I've found the "WAS IN" query, but it doesn't have a "FOR" predicate.

Thanks in advance 

[Ollie Guan]

Hi Gareth,

Can this Plugin help you？

JIRA Charting Plugin

https://ecosystem.atlassian.net/wiki/display/JCHART/JIRA%20Charting%20Plugin

https://marketplace.atlassian.com/plugins/com.atlassian.jira.ext.charting

[Gareth Bristow]

Good suggestion, but this only allows me to see average time in each status. I need to be able to see the time in status of each issue.