it's possible via a JQl filter to measure the number of US that have remained in one column ?

[Wakil BENAMOUR]

Hello ! 

I'd like to know if it's possible via a JQl filter to measure the number of user stories on a project that have remained in a single status or column for more than 5 days. Ideally, the data would be updated automatically after more than 5 days.

it's a request from our product owner to see the tickets that remain stuck on a status to centralize efforts on the progress of the ticket and display it on a dashboard.

Thank you for your invaluable help

[Tim Perrault]

Hello,

You could try something like this:

project = xxx AND status = <yourstatus> AND NOT status CHANGED AFTER -5d

[Tim Perrault]

Actually this would probably work better for your situation.

project = xxx AND issuetype = "User Story" AND NOT status CHANGED AFTER -5d