Using the resolution date filter in the right way

[Simon von Pock]

Heya,

I prepare a report every month concerning the performance of your scrum team. Additionally, I try to compare the numbers of 2020 to the years before. In order to do that, I use a filter on the resolution date.

So during the year I use resolution date filters like for example 'resolved >= 2020-03-01 AND resolved <= 2020-03-31' in order to prepare the report for march. At the end of the year I use the filter like that: 'resolved >= 2020-01-01 AND resolved <= 2020-12-31'

Problem: the results of the second filter exceeds the sum of the results of the individual months.

What am I doing wrong?!

[Jack]

TBH it is hard to say. I would step back from the numbers and rather export all issues from all filters into CSV and then look to Excel/Sheets to find where the delta is and then inspect them which should lead to the smoking gun. One other thing... you might consider this annual query

resolved >= startofyear() and resolved <=endofyear()

and if you run it in the following year and want previous year...

resolved >= startofyear(-1) and resolved <=endofyear(-1)

also consider using "resolutiondate" to see what it yields.