Tasks started and ended on a specific period of time

[Andrada Covaci]

Dear community,

I have a specific situation for which it would be helpful to use Jira JQL queries but I didn`t manage to find a way...

The need is to see which tasks we started in Q3 (so all the tasks started between July 1st and Sept 30th) and which of them were Done in Q3.  

Do you have an idea on how I can see that?

It would be much appreciated!!! 

Thanks!

[Dave Mathijs]

Hi @Andrada Covaci ,

Please define 'started' and 'done'. Is it a certain status in the workflow? Is it created date and resolution date?

Thanks to elaborate,

Dave

[Andrada Covaci]

Hi @Dave Mathijs , 

Thanks for answering! You are right, I didn`t explain it correctly.

Started = means for me the date we started to work on it. So it can be the date we added that task to a Sprint, or the date we added it to "In progress" status. Not the creation date. 

Done = is the Resolution Done.

So the main reason (the `why` from behind) is that I would like to calculate the team velocity per quarter. So I`m interested to see how many tickets we finished in one quarter, resolution DONE, (from the numbers of tickets that we started to work on in the same quarter)

Andrada

[Dave Mathijs]

You could use a jql syntax like:

status changed during ('2021-07-01', '2021-09-30') to ("In Progress")

resolutiondate > "2021/07/01" and resolutiondate < "2021/09/30"