Average - Total mode

[#1]

Hi,

I'm using a straight table where one of the columns is a count and the dimention limit is the top 7 users plus the others.

As a total I want the average of all users, but, using the total mode, it returns a diferent value.

It seems that it counts the others as one user.

Any suggestions?

Thanks in advance!

JS

[sunny_talwar]

Would you be able to share a sample? I know why it is doing this, but to suggest a work around will be better if we have a sample to work with.

[hic]

I would use the following formula:

   Count( distinct XXX ) / Count( distinct User )

If you use "User" as dimension, this will show the original number for the individual Users (divided by 1). The "Others" slice and the totals will however be divided by another number and so the expression will show the average.

HIC

[swuehl]

Maybe use a total mode 'expression total' and as expression something like

if(Dimensionality(),

     Count(YourField),

     Avg( Aggr(Count(YourField), YourDimension))

)

[#5]

Thank you very much!!