But i change rules at play)
Lets add one column and one row to Orders table:
LOAD * INLINE
[date_c, customer, region, ordercnt
2009-11-1, first, a, 1
2009-11-1, second, b, 1
2009-11-2, first, a, 1
2009-11-2, third, a, 1
2009-12-1, first, a, 1
2009-12-1, second, b, 1
And create bar chart with one dimension "Region". And expression "Sum(ordercnt)/Count(Distinct customer)"
Region A in november got 1,5. In december 1
Without selections result is 2, but i need 1,25
With formula =(Sum(ordercnt)/Count(Distinct customer))/Count(DISTINCT month) result is 1
With formula=avg(aggr(Sum(ordercnt)/Count(Distinct customer) , month)) result is 1,17 (?)
Now i am working in 8,5 version
i think it's just a problem of definition of your average.
with the first formula :
(6 orders / 3 customer ) / (2 month) = 1 => it's the average number of orders by customer and by month
with the second formula
( ( 4 orders / 3 customers) in november + ( 2 orders / 2 customers) in december) / 2 = 0.5 * ( 4/3 + 1) = 1.17
=> it's the month-average of the number of orders by customer.