Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, have a chart with a dimension Supplier and an expression average customers per day.
Here is the expression: Avg( Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))
Want in another expression to make the total average for all suppliers For example:
Supplier 1 - 10 average for all - 15
Supplier 2 - 20 average for all - 15
So how to make the expression (Avg( Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))) to do that?
Thanks
Try
=avg(total aggr(avg(aggr(count(DISTINCT Customer),Supplier,Date)),Supplier))
Or please post some sample lines of your input data.
Maybe
=Avg( Aggr( Count(DISTINCT [Customer]),Date))
or
=Avg(TOTAL Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))
Nope , it doesn't work.
I guess we missed the point.
Could you explain what the 'Supplier 1 - 10' and Supplier 2 - 20' is?
Supplier / average customers per day / average for all suppliers
1 10 20
2 20 20
3 30 20
and you want ?
Try
=avg(total aggr(avg(aggr(count(DISTINCT Customer),Supplier,Date)),Supplier))
Or please post some sample lines of your input data.