Report showing breached, open tickets by assignee

[Alison Files]

I'm trying to create a report that shows how many breached tickets are in an assignees queue.  I created a report that shows how many breached tickets were closed but I can't seem to create one that shows open tickets only.  I tried series Breached, open and assignee and it doesn't give me the correct results.

Thanks,

Alison

[Brant Schroeder · Accepted solution]

@Alison Files can you share your JQL?

[Alison Files]

Hi Brant,

Thanks for the response!  Here is the JQL:  status = Open AND "Time to resolution" = breached() AND assignee = 61b236c6f24150007289c165

Alison

[Brant Schroeder]

@Alison Files Can you change it to the following: resolution = Unresolved AND "Time to resolution" = breached() AND assignee = 61b236c6f24150007289c165

I am assuming that when you say an issue is open it has not been resolved.  A workflow can have multiple statuses that are all unresolved.  Try that and see if you get what you need. 

[Alison Files]

Hi Brant,

That fixed it!  

Thanks for your time :)

Alison

[Kateryna_v_SaaSJet_]

Hi @Alison Files 

As always actual an alternative solution, there are Marketplace add-ons that simplify work. For example, in the SLA Time and Report for Jira add-on, you can configure reports with the simple filter fields (and use the JQL if you'd like – the app also supports it).

You can try all the benefits of the application using a 30-day trial.