Check completed tasks for a period of time

David Stokes_1uektf

Are you able to check how many tasks a person completed in a set period of time (i.e. 1 month)

I was trying to advanced searches .. but not sure how to only select a certain month

 

project in (board1, board2, board3) AND status = Done AND statusCategory in (2, 4, 3) AND assignee in (person.name) ORDER BY updated DESC

 

Any help would be great.

thanks.

unknown

Hello @David Stokes - If your set time periods break by calendar months, would something like this help?

project in (board1, board2, board3) AND status changed to Done DURING (startOfMonth(-1), endOfMonth(-1)) AND statusCategory in (2, 4, 3) AND assignee in (person.name) ORDER BY updated DESC

This should bring issues from the past month because we have -1 as the parameter passed into startOfMonth and endOfMonth. This also makes sure that the staus change to done has happened in the given time period. We can adjust start and end dates based on your requirement. We can also add specific dates if you would like to replace startOfMonth and endOfMonth in the JQL above. Please read more from here to understand the usage of DURING operator. 

Hope this helps!

-kalyani