How to filter tickets that stayed in a status for a given time

Question

Hi,

My goal is to filter out tickets that stayed in "Peer Review" status for over 3, over 4, over 6 and over 10 days during a month.

I am playing with status changed but with no success.

status changed from "Peer Review" AFTER startOfDay(-1d) BEFORE startOfDay()

gives me tickets that altered the status yesterday but that is not what I am looking for.

Lists should contain unique tickets so if a ticket stays in status over 6 days it should be not present in "over 3" and "over 4" days lists.

Please help.

Cheers,
Przemek

Przemek Sech · Answer

I think I am getting closer

status changed from "Peer Review" DURING (startOfMonth(), endOfMonth()) AFTER -1d BEFORE 6d

Gregor Kasmann_Actonic · Answer

It is not exactly what you are looking for, but you can view the transition time per status per issue by installing Suite Utilities for Jira (JSU) https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities/server/overview