Ability to see work items resolved by specfic users using JQL or other means

[Gaia Sargent]

I've gone through all the documentation that I could find and couldn't find an answer to my question. Hoping you all in the community can help me out.

What I'm trying to do is this: create a filter/dashboard/report (whichever works best) to show the number of work items in our JSM project resolved by each service desk team member, separated by user. I do not want to filter on assignee, as there are some work items that our developers have worked on, and the person who deploys the change (and resolves the work item) is not necessarily the person currently assigned to the work item.

I understand this is sort of possible using an Activity Stream gadget on a Dashboard, but that isn't the visual method I am looking for. I am looking for something more along the lines of a work item filter that can be added to a dashboard or a report that I can send to leadership to reflect the true amount of work people do regardless of who is assigned to the work item.

[Trudy Claspill · Accepted solution]

Hello @Gaia Sargent 

With only native functionality it is not possible to create a dashboard gadget that display a 2D Statistics chart of Resolvers and count of issues resolved.

You can create a filter to get a list of issues Resolved by a specific user, if "Resolving" an issue can be correlated to the changing of the issue Status to a specific value:

Status CHANGED TO <resolvedStatus> BY <user>

You would have to have a separate filter for each user.

You can learn more about the options for the CHANGED operator here:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

Jira's native 2D statistics gadget is not able to set an axis of the table to the Resolver of the issue because that is not recorded in a separate field. It is just imbedded in the issue history.

A work around would be for you to add a User Picker custom field to the issues, and set that field to the person executing the transition to <resolvedStatus>, also clearing the field in the transitions where the issue might be changed to an "unresolved" Status. You could then use that User Picker field in the native Two Dimensional Statistics gadget.

[Gaia Sargent]

Hi @Trudy Claspill thanks for your reply! I opted to try your CHANGED TO suggestion as I am not wanting to create a custom User Picker field for this purpose. I was able to get it to work! Thank you so much for your help.

[John Funk]

Hi Gaia,

The only way I know to do this is to create a custom user (single picker) field and populate it with the person who moved the issue to Done. Then you could create a a dashboard pie chart showing the breakdown by the custom user field. 

Let me know if that would work and if you need further details of how to do that. 

[Gaia Sargent]

Hi @John Funk thanks for your reply! For this purpose, I am not wanting to create a custom User Picker field. I was able to take another suggestion from Trudy above to make this work.