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?!
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events