My director wants reports showing the daily, weekly, and monthly average numbers of service tickets so he can see how busy our service team is. He wants weekends and holidays excluded from the results.
I've written a formula that calculates the number of workdays for any given time period. I've also created both chart and summary reports showing TOTAL numbers of tickets. But I can't figure out how to bring these together to show an AVERAGE number of tickets per workday/week/month.
I feel like the solution's staring me in the face, but I can't see it yet. Any suggestions?
Question
Averaging Reports
This topic has been closed for replies.
+24I suggest that you make a formula checkbox field called
[Today is a Weekday?]
The formula will be
DayOfWeek([Ticket Date]) <>0
and
DayOfWeek([Ticket Date]) <>6
Then just make a summary report and filter out the weekend tickets using that checkbox.
You should be able to use the # of records twice on the summary report to show both total number and the average.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
[Today is a Weekday?]
The formula will be
DayOfWeek([Ticket Date]) <>0
and
DayOfWeek([Ticket Date]) <>6
Then just make a summary report and filter out the weekend tickets using that checkbox.
You should be able to use the # of records twice on the summary report to show both total number and the average.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.