Filtering tasks based on time in status

[Clayton Winders]

I am trying to build some filters for insights into tasks that have been sitting in a status for too long. Ideally, I would like to be able to see tasks that are sitting for 0->1d, 1->7d and 7d+.

Currently we have 138 tasks in To Do/In progress, with 12 being updated within the last day. How can I create a filter to show these 12 tasks that have been updated today?

When trying to use 'status changed AFTER/BEFORE' JQL will pull all tasks that fit that property, as in all tasks that were changed within a 1d time period, not tasks that were changed within the last day. 

[Petter Gonçalves]

Hello Clayton,

Unfortunately, it is now possible to return issues that have spent a specific amount of days in status, however, there are some add-ons that can provide you with this information.

That been said, you can use the Pivot by Statuses report provided by the Time Reports add-on to get this information:

Let us know if this add-on would be an option for you, Clayton.

Have a nice day!