Forums

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

Check completed tasks for a period of time

David Stokes June 21, 2019

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.

1 answer

0 votes
Deleted user June 24, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events