topic Re: Avg Aggr only returning first number of data set in App Development

Avg Aggr only returning first number of data set

mikegrattan — Wed, 22 Dec 2021 15:42:54 GMT

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.

Re: Avg Aggr only returning first number of data set

sunny_talwar — Mon, 20 Mar 2017 17:42:05 GMT

Try this:

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

Re: Avg Aggr only returning first number of data set

mikegrattan — Mon, 20 Mar 2017 17:44:47 GMT

Perfect. Thanks for the quick answer.