1 Reply Latest reply on Aug 6, 2012 9:10 AM by Tracy Rodgers

    Max Number of Records by Weekday

    Lance Leonard

      I have a set of data that contains date and timestamps for when each record was created. I need to show the average and peak records created by weekday. For example, what is the average number of records created on Mondays and what's the peak/maximum number created on Mondays. I had trouble with the averages, but found my answer in another post, here. That was a huge help! But, now I'm having trouble doing the same thing with a maximum calculation. My brain hurts from the average, so I'm not even sure how to calculate the maximum. Thanks in advance.