The Greenhopper cards show how many days the card has been in its current column. I would like to create a filter that show all issues that have been in a column for more than 5 days. It seems this would be possible since the cards show the data I would need to calculate on.
The business reason behind this is to create a focused list for a weekly management meeting to review "exception" issues that might need some management attention. This would be easier than hovering over every card in a complex board with a large number of cards.
This should not be the accepted answer. Alexander Shocke gave a good answer below.
I would suggest using During though. If you use Not Changed DURING(-5d,now()) you select issues that have not left the column. Before will show anything that moved to WIP before that, even if it left the column and returned to WIP.
status = "In Progress" AND status changed to "In Progress" before "-5d"
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs