How can I create a JQL search with a count on a specific field

Question

Hello everyone,

I am trying to create a filter, where i get an output, when at least 2 open issues are related to the same reporter.

For example

Ticket 1: Customer 1
Ticket 2: Customer 2
Ticket 3: Customer 1
Ticket 4: Customer 3
Ticket 5: Customer 3

Filter now should show me Ticket 1, 3, 4, 5

I hope this explains my aim well enough

Thanks in advance
Chris

Chris S__htsfc7 · Answer

Thanks a lot to everyone for your replies.

I want to create a Dashboard where all cases are shown from our customers or organizations, which have at least 2 open cases (Maybe some time in the future, this 2 will go up).
Currently the Dashboard shows about 600 issues, from which around 400 are opens from one reporter or around 300 from one organization. I looked for an option to filter this "one-reporter-entries" or "one-organisation-entries" out to have a better view

Rebekka Heilmann (viadee) · Answer

Hi @Chris S_ and welcome to the Community.

With default Jira you cannot create a filter achieving that as you can't limit the results in terms of number of results or other conditions.

What are you doing with these issues? There might be Dashboard Gadgets that go in the right direction, but unsure why you need the filter to begin with.

Issue Statistics can give you total issue counts for instance.

Avinash Bhagawati _Appfire_ · Answer

Hi @Chris S_ ,

With native functionalites, you cannot filter out issues based result count. However you can make pie chart or gadget in the dashboard to display the count data for reporter. Please find below sample screenshot for your reference.

Thanks,
Avinash