I have a scorecard view of a various calculated series' saved with a Current Quarter date filter. If I Update Date Filter with Last Quarter, is the calculated series now showing me an average of the three months in the quarter? How is it taking all 3 months worth of data and providing me the calculation? The reason I ask is because if I take the calculation for each month individually and divide it by 3 I get different values than if I select the Last Quarter date filter.
Tickets Open = A
Tickets Closed within SLA = B
Calculation = IF(A=0,0,(B/A)*100)
So for example, I update the date filter to Last Quarter
And I get the following value:
However, if I take a static date for each month over the course of that last quarter (OCT: 96.1; NOV: 94.7; DEC: 93.9) I get 94.9. If I take the static dates from OCT 1 - DEC 31 I get the 95.1 value like I would with the Last Quarter date filter.
Now while this is not a large variance, it is enough to raise questions on how the built in calculation is being done and why the values are different.