Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage of resolved tickets that hit certain status per assignee?

Rosa M Fossi
Contributor
March 22, 2019

Is there a way to report / retrieve the following data:

What percentage (per assignee) of resolved tickets went through status "re-do" in the last 90 days?

It's easy enough to come up with a JQL and use a Pie Chart that yields the total of tickets that resolved in the last 90 days which went through status re-do. 

resolved > -90d AND status changed to Re-work

But I'm not sure if I'm asking for the moon here to be able to get percentage results per Assignee.... Basically, I need to know what percentage of each assigness' resolved tickets in the last 90 days went through re-do

1 answer

0 votes
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 25, 2019

Hi Rosa,

Your on the right track, to get a percentage per assignee I believe the Pie chart is your best option.

Next to fine tune the filter to get the issues that are resolved, but also passed through the particular transition, Try Using "was in" instead of "changed to" like this:

resolved >= -90d AND status was in (Re-work)

 I would also recomend doing another minor edit and add in a ">=" and a "startOfDay()" modifier to make sure you get the full days data as the JQL results will return issue relative to the time the jql is run:

resolved >= startOfDay(-90d) AND status was in (Re-work)

 Let me know if this does the trick, and for an referance point additional details of available JQL options can be found HERE

Regards,
Earl

Suggest an answer

Log in or Sign up to answer