Number of breached tickets for the past 7 days

Question

Hi,

I am trying to figure out how to pull SLA data on breached tickets. I want to know breached tickets at the start of each week from the previous week.

I do not want to put a ticket creation date parameter on this because some of our SLAs are a month or two long [depending on priority]. I just want to know the total number of breached tickets for the past 7 days for example.

Is this possible? Is there any JQL trick?

Thanks

Fabio Racobaldo _Catworkx_ · Answer

Hi @Albert Manuel ,

JIra doesn't store the breached event time so you can't do that. There's an open request for that https://jira.atlassian.com/browse/JSDSERVER-174 and it could be usefulf for put in place a JQL as per your needs.

Fabio

Albert Manuel · Answer

@Fabio Racobaldo _Catworkx_as i said in the initial request I do not want to use the created date parameter on this because some of our SLAs are a month or two long

Fabio Racobaldo _Catworkx_ · Answer

Hi @Albert Manuel ,

you can do that defining a your own report based on a specific filter that containg "created > startOfWeek() "

So create a report, add a series and add a filter by condition. Something like this :

Hope this helps,

Fabio