Resolution champions counts to Jira

[Ludovic L_Hoir]

Hello,

We’d like to set up a monthly automation to share the "Resolution Champions" list in a dedicated Slack channel, allowing the entire company to recognize our top agents. Ideally, this list would include both the assignee's name and their resolved ticket count. If the count isn’t feasible, just listing the names would also work.

Currently, we have the "Resolution Champions" report on our dashboard, but sharing it directly on Slack would make it more visible and boost morale across teams.

I’ve explored creating an automation based on a JQL query, but I couldn’t find a way to retrieve the count of resolved tickets per assignee directly. Could you guide us on how to best achieve this?

Your support would be greatly appreciated, as this recognition would mean a lot to our agents.

Thank you!

[Marios Marneros]

Hey @Ludovic L_Hoir , welcome to the Atlassian Community! It is really nice that you would like to recognise your employees! Very nice idea!

A way you could do it using Jira automation is by retrieving a list of your agents, this can be by role or group or team. The trigger can be a scheduled rule (weekly, monthly, etc). Then you would get a list of users and set it as a smart value. You can then loop through that list using the for each loop action and set a variable with the name of the user as well as do a JQL search and get the count of issues resolved. You will need to store that somewhere, maybe a smart value, a lookup table or even a custom field (Create lookup table action). Then when you use the slack message action you can use the smart values as variables in your JSON. Something to note, smart values and lookup tables can be accessed within the same branch of the rule.

This will need some trial and error from you and to see what works best for you! You might also be able to do something hacky and hard code things to get a working solution in place before making it more complex.

I didn't provide a complete solution but I hope I gave you some ideas that can help you develop your own solution! Let me know if you have any questions on the implementation. I hope this helps, good luck!

Documentation:

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table/

https://support.atlassian.com/cloud-automation/docs/smart-values-in-jira-automation/