Tasks started and ended on a specific period of time

Question

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 · Answer

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"

Andrada Covaci_90hb5y · Answer

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 · Answer

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