I am trying to setup a filter in the Kanban view, based on the number of days an issue has been in a specific workflow status. I have setup a workflow where an issue will move from "Backlog" to "Planning". I would like to know if the issue has been in Planning for more than 3 weeks. I know you can turn on the "Days in Column" feature, and hover the dots on the Card to see the actual number of days, but I'm looking for something better.
try this. i haven't tried so some tweaking may be required
status = "Planning" and status was in "Backlog" BEFORE startOfDay(-15d)
now what the above does not take into consideration is the case where the issue was in the backlog and then moved to planning and then moved back to backlog and then moved back to planning. but that is a corner case.
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