Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to calculate number of updated ticket per agent?

Sami Purho October 27, 2017

I am looking for a way to calculate how many tickets our agent users are updating on daily basis/per agent? "Updating" can anything from adding a comment or updating one or multiple ticket fields.

Any suggestions or plugin which I could take a look to complete something like this?

Basically we should be able to have some kind of report which shows how many tickets our agents have been updating each day.

1 comment

Tayyab Bashir
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 28, 2017

Hi,

You can construct a JQL query for this purpose and include all the clauses that you need.
Now for some functions you would be able to find them in default JIRA and for others you would have to use plugins. 

For e.g. You could use the following JQL, which would return all the issues for a user, which have been either commented on, logged work on them, or their status has been changed. 
The query restricts to include issues for just 1 day (as you wanted daily basis) but you can change that to whatever timeframe you want it for. 

(worklogAuthor = user and worklogDate > startOfDay(-1)) 
OR (status changed by user AND status changed AFTER startOfDay(-1))
OR (issueFunction in commented('After -1d by user'))

(replace the user with actual username)

The last clause of issuFunction in commented is coming from ScriptRunner plugin. 

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events