Average per day

[tezread]

Hi thereI am trying to work out the average number of episodes per day. I have a tableEpisodeIDDatecould anyone help?

 

[John Big Booty]

Have a look at a GroupBy (total) Query, perhaps this article will give you some pointers.

You could Group By your date field, and then use the Avg to return the average for that date.