Was ticket in a sprint during a given period

Billy Kelly

Hi all, 

I've been looking to expand on a structure to help me track tickets completed in a given month and initially was using JQL status WAS IN "In Progress" DURING ("2022/03/01", "2022/03/30"  to do this but this query doesn't work and the number of statuses we use will make this hard to use, plus this will be tickets from across multiple projects

I was wondering if I can use sprint.startdate and sprint.enddate in a formula to capture all the open/closed sprints during the month of March? From here, I can just sum over the column to get the total tickets and current multiple columns for each month

Would be good to know if anyone has done this before or if a better approach should be used 

 

Thanks 

Nicholas Ellis _ALM Works_

Hi Billy,

You could use the sprint dates, but there are some interesting complications you can run into, such as an issue being in multiple sprints.  I would use the resolved date, and then define a date range around it.  for a trailing date I might do something like this:

IF DAYS_BETWEEN(resolved, NOW()) < 30: 1

or if you wanted to be more specific to the actual month you could do something like:

IF JQL { resolved < endOfMonth(-1) and resolved > endOfMonth(-2) } : 1

Both of these Expr fucntions will return 1, when the condition is true.  Then you can simply click "sub over sub-items" to get an issue count.

You could also replace the 1 with an estimate field if you wanted to sum that up as well.

Cheers,
Nick
[ALM Works]