I am trying to get the average number of cases per weekday (in this case, Monday thru Saturday). I have a date-time field that I can get a count on the total number of cases, and I use a formula called 'weekday name', with the formula:

weekdayname(weekday({table.datetimefield}))

to get the day, then group them by day. However, I can get only a TOTAL number of cases for ALL the Mondays,
Tuesdays, Wednesdays, etc. in the date parameters I have set.

 I saw somewhere else where using a distinctcount function would get me the number of Mondays, Tuesdays, etc. However when I use it in a formula, I get errors.
I am stuck on trying to get the number of Mondays, Tuesdays, Wednesdays, etc. in my date parameters. My plan is to divide the total number of cases for all the Mondays, Tuesdays, etc into the number of Mondays, Tues., etc. in my timeframe.

  Thanks in advance.
  

Edited by kitster100 - 08 Sep 2011 at 6:03am