How do I filter users that have issues in a non closed state that have more than 2 issues?

[Ruth Norton]

We are trying to enforce a 2-ticket work in progress tickets for our guys so we don't end up with 20 tickets active for each assignee.  I want to create a filter that shows me all users that have more than 2 active tickets (meaning not in the backlog and not closed).  What's the best way to author the JQL query?

[RKusmba · Accepted solution]

GROUP_BY clause is not provided in JQL.

You can query active tickets with user column and export the JQL results into Excel spreadsheets and group by users using the Better Excel Plugin.

You can find more info in below on using gadgets to group by specific field:

https://community.atlassian.com/t5/Jira-questions/Group-Items-in-Filter-Search/qaq-p/205687

[Ollie Guan]

Hi @Ruth Norton,

As Rajendra Kusumba said, JQL does not support GROUP_BY.
You can try to implement this part of the function through Two Dimensional Filter Statistics in DashBoard.