topic Re: Aggr with mode function in App Development

Aggr with mode function

Adrian1 — Sat, 16 Nov 2024 18:26:23 GMT

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!

Re: Aggr with mode function

Lauri — Fri, 26 Jun 2020 15:10:34 GMT

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?

Re: Aggr with mode function

Adrian1 — Tue, 30 Jun 2020 13:11:43 GMT

Yes you're right.

It works with

Aggr(mode(Discount), IdCustomer) like dimension

and count(Distinct IdCustomer) like expression