Aggr with mode function

[Adrian1]

Hello,

I hope somebody can help me with this.

I would like to know how many customers have a certain discount as the most repeated (mode function).

I try this, but it doesnt works:

Count ( Aggr ( mode(Discount), IdCustomer) )

thanks!

[Lauri]

I suspect that returns the count of IdCustomer, which isn't very helpful. Your Aggr function is returning a list of IdCustomer and their mode. Then your Count function is just counting them.

Are you picking a value of discount in the app, and hoping to see how many customers have that as the most repeated?

[Adrian1 · Accepted solution]

Yes you're right.

It works with 

Aggr(mode(Discount), IdCustomer) like dimension

and count(Distinct IdCustomer) like expression