Avg Aggr only returning first number of data set

[mikegrattan]

I am using the following expression in an attempt to return the average number of orders processed per day, for the last seven days, for the specified warehouses.

Avg(Aggr(Count(DISTINCT {1<IsInLast7Days = {1},Warehouse = {'YSS','SSS'}>} SalesOrder),Date))

The actual data set from the chart looks like this:

The chart data looks fine, and uses the following function:

Count(DISTINCT {1<IsInLast7Days = {1},Warehouse = {'YBF','SBF'},Date>} SalesOrder)

However, the reference line only picks up the first number instead of the average.

Any suggestions would be appreciated.

[sunny_talwar · Accepted solution]

Try this:

Avg(TOTAL {1<IsInLast7Days = {1},Warehouse = {'YSS','SSS'}>} Aggr(Count(DISTINCT {1<IsInLast7Days = {1},Warehouse = {'YSS','SSS'}>} SalesOrder),Date))

[mikegrattan]

Perfect.  Thanks for the quick answer.