Forums

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

The JQL for getting monthly true dates

argine.avagyan October 27, 2022

Dear Atlassian community, we need to consult about the following case, 

We want to get true monthly data about our team loading process

  • how many tasks were assigned during the month 
  • how many tasks do they start to do during the month 
  • how many tasks they resolved during the month 

We need to get all data of a particular month which can truly show all the load/activity of the team․

P.S We can't use updated date-field data created because we often make changes in our workflow, and all tasks will be updated, and this is not true data that we need. A created date does not give true because tasks easily can be created in previous months. 

We are thinking of adding new fields example: Start date or assigned date. If you know other ideas or solutions, we are happy to know about this. 
Thanks in advance!

1 answer

1 accepted

0 votes
Answer accepted
Mark Segall
Community Champion
October 27, 2022

Hi @argine.avagyan and welcome to the community!

Try these queries...

  • how many tasks were assigned during the month 
    • Assignee CHANGED AFTER startOfMonth()
  • how many tasks do they start to do during the month 
    • statusCategory != "To Do" AND status CHANGED AFTER startOfMonth()
  • how many tasks they resolved during the month 
    • Resolved >= startOfMonth()
argine.avagyan October 27, 2022

I will try, thank you so much!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events