So i have a table that is a system_log table. What i would like to do is show on a chart the days of the week on my X access Mon-Fri.
Y Access would be labeled traffic.
Basically what im trying to measure is on what day of the week is the most busiest the system is being used.
On system_log table i have a timestamp field, and then a calc field that is a pattern count to log how many times a particular message was logged.
What i would need to do is summarize the total records of that pattern count were for one day and then some how translate the timestamps to be counted under that particular day of the week. How can i do this ?
Thanks for your help.