Calculate Average Orders per Day?

[specpharm]

Hiya All,

This is probably dead easy but it's got me a little stumped.

I've got a table that holds a record for every order we receive. It contains a date field that holds the date the order was created. I'd like to be able to calculate the average number of orders per day.

It seems simple enough to calculate how many orders came in on any given day - self-join based on date field, calc field with count (Join Table: Date).

But getting an average of that calc field would give a completely skewed result since a day with 6 orders would be counted 6 times, etc.

Is there any way of doing this? Optimally I'd like to put all the dates in a portal showing how many orders each one had ...

Any help would be greatly appreciated!

[machon]

Did you finally got the way to do it??/ I have the same issue with a project right now..