Percentage of resolved tickets that hit certain status per assignee?

Rosa M Fossi

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

Earl McCutcheon

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