Percentage of resolved tickets by assignee

[Bolaji Jegede]

Is there a gadget that shows the percentage of resolved tickets by assignee or is there a way to add a custom field to statistic type to get this report?

[Bill Sheboy · Accepted solution]

Hi @Bolaji Jegede 

Would you please clarify a bit as that may help the community to offer better suggestions?

Specifically, what is your "percentage of resolved" ( X of Y possible) based upon:

• all issues resolved within a window of time
• all issues resolved for children of an epic (or linked issues)
• all issues resolved during a sprint
• etc.

And, what problem are you trying to solve by having this information?  What would you do differently if you had that info currently?

Kind regards,
Bill

[Bolaji Jegede]

Many thanks @Bill Sheboy for your speedy response.

I want to know the percentage of all issues resolved during a sprint by assignee. Basically this is to help me know the completion rate for each assignee in a sprint.

E.g, Assignee "A" had 5 issues at the start of sprint and completed 3. That's 60% completion rate for Assignee A.

I would be glad to know if there is another way to get this information. 

Regards

Bolaji

[Bill Sheboy]

Thanks for that clarification...and...

You seem to be measuring something for individual people when a Scrum team usually works collaboratively to share the work.  Doing this could lead to unintended side-effects and problems for the team.  It may be helpful to instead have discussions with the team if you have concerns about issue completion rate.

With my observation out of the way...

Once a sprint starts is work shared/re-assigned to others?  If so, this may be difficult to see what you ask.

Otherwise you may do what you ask using the Pie Chart dashboard gadget and a saved filter.  The filter would be something like:

project = myProject AND sprint IN openSprints() AND statusCategory = Done

If you use the saved filter and select Assignee for the value, the pie chart will show slices for who is *currently* assigned to the completed issues in the open sprint.  If you instead need to specifically show percent complete for a person, you would use a filter for that person and change the gadget to display status instead.

[Bolaji Jegede]

Thanks Bill.

This is a request from the Team Leads after discussions about completion rate. They would like to see how the individuals within their team are performing in terms of completion rate. Usually, work is shared between the team members at the start of sprint. 

I'm open to learn a better way to deal with this situation where completion rate is continuously low from sprint to sprint. Individual/Team workload is always moderate in any given sprint with an allowance for any unplanned tasks. However completion rate never improves.

I will try the filter you suggested and let you know if it works.

Btw, can I add more than one project in JQL?

Thanks

Bolaji

[Bill Sheboy]

Yes, you can do that with the IN statement.. For example:

project IN (myProject1, myProject2) AND...

If you save the filter and use it for a dashboard, it would roll up all the results.

Please note: company-managed and team-managed projects appear to expose their fields differently, so if you combine different project types in the JQL and put it on a dashboard there may be unpredictable results.  I suggest trying what you need and if it doesn't work, post a question to see who has ideas to help.

[Priyadharshani Pandiyan]

hi @Bill Sheboy , I'm looking to create a dashboard that can help to check the no. of tickets assigned vs the number of tickets that were acknowledged within the Time to first response, Resolved within the SLA and the % of tickets that have breached in JSM. This dashboard is for the management to view the team's qualitative vs quantitative effort. 

Can you please suggest queries or a dashboard tool to address the ask. 

[Bill Sheboy]

Hi @Priyadharshani Pandiyan 

I am not using JSM and would not know which queries to suggest.  Some of the things you ask seem to be in the built-in fields, so perhaps look over the Advanced JQL reference for JSM to see how that helps:

https://support.atlassian.com/jira-service-management-cloud/docs/jql-fields/

Kind regards,
Bill