Query for number of tickets resolved in a project, grouped by person who resolved them

Question

Hi,

I want to incentivize my team to resolve tickets in our project.

To do this, I want to create a leaderboard that displays who resolves the most tickets. The query behind this would have to display total tickets resolved, grouped by the user who preformed the "resolve" action in the workflow.

Is there an easy way to do this? Currently, I have to write a separate jql query per person using this query:

project = "IT project" and status was Resolved by [USERNAME] before now() after "2000-01-01"

Thanks.

Jack Brickey · Answer

"Status was resolved by" doesn't exist as you found. Can you not assume that "status was resolved by" is equivalent to Assignee AND status = Done? In other words would using the following JQL filter work?

project = "IT project" and status = Done and resolutiondate <= now() and resolutiondate >= 2000-01-01

then apply that filter to the 2D chart and use Assignee in the y-axis and status in the x-axis

Jessica A · Answer

Hi Jack, It doesn't seem like the two-dimensional gadget has a field for "status was resolved by" that I can map to an axis.

Jack Brickey · Answer

create a Dashboard and use the two-dimensional gadget or similar.