Looking for a COUNT of issues that exceeded a time limit in status historically

[Kenneth Penttinen]

We have a work flow which has our team moving issues from OPEN to IN PROGRESS when they begin work and I'm looking for a way to count the number of tasks that exceeded 24 hours in OPEN status. 

It's easy enough to track live the issues that are currently in OPEN that have exceeded the 24h threshold, but is there an easy way to look at n weeks ago and count the number of tasks that exceeded the threshold for that week?

[Jack Brickey · Accepted solution]

not an easy way to do that OOTB. Maybe take a look at an addon like Time in Status. Service desk has a nice SLA feature but not JSW. You could achieve w/ other addons, e.g. Scriptrunner too so maybe you already have something in place that could work for you.

[Taranjeet Singh]

@Kenneth Penttinen You can make use of JQL functions like "startOfWeek()" and "endOfWeek()" with their optional time unit increments ((+/-)nn(y|M|w|d|h|m), along with operators like <, >, <=, >=, as required to filter JQL results based on a time period (i.e. weeks)

Please refer the below Atlassian docs for these functions for more information:

https://confluence.atlassian.com/jirasoftwareserver073/advanced-searching-functions-reference-861256240.html#Advancedsearching-functionsreference-startOfWeek

https://confluence.atlassian.com/jirasoftwareserver073/advanced-searching-functions-reference-861256240.html#Advancedsearching-functionsreference-endOfWeek