...
- the Monthly Pivots worksheet has pivots that just average whatever they see in the acd-per-day tables. If you leave in weekdays with zero values because they were holidays, then the quarterly averages are dragged too low. Remove any lines with zero days.
- Use the ACD monthly-gate-traffic report files to count the number of working days in a month. Use that number to determine the divisor of all these something-per-day statistics.
Dashboard Pivot Tables of multiple queues swerve if N of Queues changes
...