"Group By" Queries and Counts - Are they possible?

[Jesse Willcocks]

Hi,

I would like to run a report of tickets resolved by users with then a count of the ticket numbers each person has completed. Is this possible to achieve? 

Thanks,

Jesse

[Tarun Sapra · Accepted solution]

Hello @Jesse Willcocks

The out the box reports which you can use is the pie-chart and 2 dimensional gagdet in jira to get this stats, i.e. tickets resolved per assignee. 

Though there are some advance reporting Jira plugins as well like eazyBi, dataplane but in your case default Jira features should suffice

[Yogesh Mude · Accepted solution]

HI @Jesse Willcocks

Welcome to the community.

You can run the jql like assignee in ( userA, userB) and status in (resolve, close) and save the filter.

Or else if you want to fetch the report by the group then use ....memberOf(group_name)

using the saved filter you can be able to see the resolve issue count on issue navigator or on the dashboard using issue filter gadget, Two-dimensional gadget.

[Jesse Willcocks]

Hi Tarun and Yogesh,

Thanks for your quick responses. They are appreciated. 

Best regards,

Jesse