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.
I think it depends on the view that you're creating. However, by simply using the max aggregation when the weekdays are on the view should give the desired outcome. Would you be able to post a sample workbook (twbx file) or screenshot?