Averaging Reports
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...
Forum Discussion
Hi Mark! Thank you for the suggestions. I'm able to filter out the weekend tickets OK.
Unfortunately, I can only use the # of records to show only totals (see below screenshot). I only have the option to select averages if I select a different (numeric) field from my table, but since the # of records isn't technically a table field, I'm missing that option. Am I missing something else to make the # of records also show the averages here?
------------------------------
Allison
------------------------------
Unfortunately, I can only use the # of records to show only totals (see below screenshot). I only have the option to select averages if I select a different (numeric) field from my table, but since the # of records isn't technically a table field, I'm missing that option. Am I missing something else to make the # of records also show the averages here?
------------------------------
Allison
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOK,
Plan B. Make a formula numeric field called [Number of Tickets]. Make the formula be a 1.
Now you have a numeric field and you should be able to do Totals and Averages.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Plan B. Make a formula numeric field called [Number of Tickets]. Make the formula be a 1.
Now you have a numeric field and you should be able to do Totals and Averages.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------