Count the number of times a ticket is re-assigned within a specific time frame

Jeanne Howe
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 2, 2015

Is there a way to count the number of times a ticket is re-assigned within a specific time frame.

We are trying to find how many times a ticket is re-assigned within the first 48 hours after creation. The JQL function Changed During - assignee changed DURING (-2d, -1d) - will tell me if it has been changed, but does not tell me how many times it was changed. I am specifically trying to find tickets that were re-assigned more than 3 times within the first 48 hours of creation.

1 answer

1 accepted

0 votes
Answer accepted
GabrielleJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 2, 2015

Yes there is a way but it's not out of the box, so you need to do extra effort to accomplish this. Manually (without any paid plugin)

  • Custom Field Counter - create a number custom field and  increment this number via a workflow transition post-function to 1. (this is assuming you only change the assignee via a transition and this does not limit it to the last 48 hours). You can just create a Subscription filter that runs everyday to fetch this data so you will have the correct number on the last 48 hours
  • Parse the Issue History - get the Issue History and parse what you need (get the issue status on a particular date and match if it's Asssigned and put in the data condition). We have accomplish this before so it's feasible.

There maybe plugins that do this, try searching the marketplace

Suggest an answer

Log in or Sign up to answer