topic second value for mode() in App Development

second value for mode()

StefanoStucchi — Tue, 30 Jan 2024 16:15:19 GMT

I would try to get the second value for a mode() function

explain:

in a table like this

the mode of Euro is 10 : mode(Euro) = 10

but how do I find the second value for a mode()?

in the example above it should be 5

I try to do

mode(if(Euro<>mode(Euro) ,Euro))

but it's a nested aggregation and it's not allowed....

So I try with aggr but sure I'm definitely doing something wrong...

mode(aggr(if(Euro<>mode(Euro),Euro),Euro)) gives me only null values...

any help is appreciated

thanks

Anil_Babu_Samineni — Wed, 31 Jan 2024 05:24:35 GMT

Max(Aggr(Mode(Euro), Euro), 2)

StefanoStucchi — Thu, 01 Feb 2024 10:07:20 GMT

Hi Anil

Max(Aggr(Mode(Euro), Euro), 2) gives me the second value of Max(Euro), not the second Mode()

Anyway I've find the solution:

firstsortedvalue(Euro,-aggr(count(ID),Euro),2)

thank you !!!