Exclude results with total less than a certain amount

[Hessel.Friedlander]

When doing a Jira filter, is there a way to exclude results where the total is less than a certain amount?

For example,

status in (Shipping, Installation, "Ready for Installation") AND resolution = Unresolved  ORDER BY assignee.

I don't want to see results if an assignee has less than 5.

[Rebekka Heilmann _viadee_]

Hi @Hessel.Friedlander and welcome to the Community,

there is no way to achieve that with JQL.

A workaround might be to use a Dashboard and a 2-dimensional Filter Gadget. You can have Status and Assignee on the axis. You can sort that by "Total" which would give you the number of assigned issues per person in this case.
However, you cannot "cut" at a specific total but only set a max. number of results.

This is the Server docu but still works the same in Cloud: Adding the Two-Dimensional Filter Statistics Gadget | Atlassian Support | Atlassian Documentation

[Hessel.Friedlander]

Thank you for the reply!

I am using the filter in the dashboad and that's exactly where I want to cut it.