Hi @Wojciech Cora ,
Thanks for posting in community.
I am not sure of how your workflow is configured.
It would be great if you could respond to the above to answer your query.
Ok No worries @Wojciech Cora .
But the criteria of the JQL would depend on answers to these(because writing a JQL doesn't help us to find the solution until we know how these projects are configured e.g. - EPIC STAUSES one of the field used). More Over, Road maps would be the better option if enabled instead of using writing JQL because the roadmap was created to check the EPICs completion.
How about using JQL, such as:
project = myProject
AND issuetype = Epic
AND statusCategory = "In Progress"
AND NOT status CHANGED AFTER -4w
Please look here for more information on advanced JQL:
Hi @Wojciech Cora ,
As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.
Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.
For you specific case, you can export the report into excel and sort results by "In development" status duration.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events