Using JQL to search for who flagged most issues in a project

New to JIRA & JQL, how can I search for which user on a project has flagged or raised the most issues using JQL?

2 answers

1 accepted

This widget could not be displayed.
Tarun Sapra Community Champion Oct 13, 2016

Easiest way to do it is to search for that project in JQL like

project  = "xyz"

and then create a  pie-charts based on reporter and it will become clear which user has created/ flagged the most issues.

This widget could not be displayed.
Jack Brickey Community Champion Oct 13, 2016

Emma,

Tarun's answer is correct assuming you want to be able to regularly see at a glance the distribution based on individuals. You will, if you haven't already, want to create a dashboard and add the desired gadgets. Note if you are looking at an entire project you don't need to create a filter since you can list the project key in the filter/project field of the gadget. Good gadgets for this type of solution are:

  • pie chart (ok if you just want percentage),
  • two-dimensional (great for illustrating more details, e.g. individual vs. status or individual vs. priority, etc.), 
  • issue statistics (similar to pie chart but w/ more detail)

Now, if you aren't really looking for a dashboard solution and simply want to create a list then all you need to do is to filter on the project and add the columns you want, e.g. "Reporter", "Assignee", etc. Of course as the list gets long, and it will quickly, you can't really assess distributions, hence the use of dashboards.

BTW, unsure what you meant by "flagged". Hope this helps.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

139 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you