problem with chart

[leetprog]

Hello,
I'm having trouble creating a chart in CR9.
The chart has to display the average count of items that were sold each day.

In the chart I have grouped each day and for each day I have a total count of the number of orders. But when i try to take an average of that total count, it won't work.

I have taken a formula to count the number of orders:
@total:
count({tblName.ID}) but this formula counts all records.
Now I want to apply a count for each day...

Thanks in advance.

 

[Wallie12]

I would change from using a formula to count the number of orders (@total and count({tblName.ID}) to insert summary using the count at the group level.