Average of average?!

[ivan_will]

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

[swuehl]

Maybe

=Avg( Aggr( Count(DISTINCT [Customer]),Date))

or

=Avg(TOTAL Aggr( Count(DISTINCT [Customer]),Date, [Supplier]))

[ivan_will]

Nope , it doesn't work.

[whiteline]

I guess we missed the point.

Could you explain what the 'Supplier 1 - 10' and Supplier 2 - 20' is?

[ivan_will]

Supplier  /   average customers per day / average for all suppliers

1               10                                       20

2               20                                        20

3               30                                        20

[whiteline]

and you want ?

[swuehl · Accepted solution]

Try

=avg(total aggr(avg(aggr(count(DISTINCT Customer),Supplier,Date)),Supplier))

Or please post some sample lines of your input data.