2 Replies Latest reply: Mar 20, 2017 1:44 PM by Mike Grattan RSS

    Avg Aggr only returning first number of data set

    Mike Grattan

      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.