Filter query for cummulative time in status

Question

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

Gareth Bristow1 · Answer

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.

Ollie Guan · Answer

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