JQL filter Time in Status

[David Pratten]

If you are wanting to filter for more than (say) 14 days time in status the idiom is as follows

created > -14d and not status changed during (-14d, now())

[Anett Braun]

Hey @David Pratten 

I would try to do it in two steps.

1. create a filter with the positive statement - created in the last 14 days and changed status in the last 14 days - save and get Filter ID
2. create a filter to list all created in the last 14 days and then subtract !=[The positive statement filter]

With pictures:

First check how many items I created in the last 14 days (result - 9)

The check the postive statement - how many items changed status (result - 2)

Then check the last step - combine != with the [The positive statement filter] (result - 7)

When the basic combination works you can fine tune with other filter elements (Project, Task, Assignee...etc)

Similar solution: 
https://community.atlassian.com/forums/Jira-questions/Subtract-results-from-one-filter-from-another-filter/qaq-p/1038415