Unique Assignee Reporting

Question

I'm trying to find out if there is a way to either export a report or create a dashboard of tickets in which a user/assignee has touched/worked on a ticket in the history of the generated ticket. Example: I'm on the operations team and I assign a ticket to someone on the technical team and once resolved they assign it back to me in which I close it.

How can I figure out/count that ticket towards the technical team without having to go into each and every ticket and reading through it. Essentially finding out which tickets they've touched/assisted with even though they re-assigned it back to me.

Thank you in advance!

Yuliia_Borivets__SaaSJet_ · Answer

Hi @George Cadena

You may check out this article: How to get assignee history for Jira issues

I can recommend a solution from my team. Below is the report you can get with the Issue History for Jira app (there is a free 30-day trial). It records assignee changes for all issues in one place. So, you can see who was assigned to the issue at different points in time.

I guess it can be helpful for your case. If needed, you can also export the report and count the changes in Excel or CSV.

Bill Sheboy · Answer

Hi @George Cadena -- Welcome to the Atlassian Community!

That information on assignees is in the issue history; it is just challenging to report on it with the out-of-the-box Jira features.

First thing, I recommend chatting with your Jira Site Admin to learn if you have any reporting addons that might help.

Next, there are JQL operators such as WAS IN that could be used to report (or show on a dashboard) issues which were previously assigned to someone, or a list of users.

For example to show issues assigned to a couple of users on a team during the first quarter of the year:

project = myProjectName
 AND assignee WAS IN (userOneId, userTwoId) DURING (startOfYear(), startOfYear("+3M"))
 ORDER BY Key ASC

Please look here to learn more about that JQL operator and functions:

* https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#WAS-IN
* https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfYear--

Kind regards,
Bill