Get second Maximum using expression...

[pratikpathak]

Hi, I'm trying to find second maximum using custom expression, i know max([timeperiod]) gives maximum value from timeperiod, my question is how can i get Second maximum value using expression?

best regards,

Pratik Pathak

 

[Gaia Paolini]

have you tried using Rank or Denserank?

[pratikpathak]

1 hour ago, Gaia Paolini said:

have you tried using Rank or Denserank?

Not Yet,
Would you please explain how I can achieve this task using Rank/Denserank

[Gaia Paolini]

You could define a column that ranks your [timeperiod] in descending order:
 

DenseRank([timeperiod],'desc')

then use it to find the maximum value of the expression DenseRank([timeperiod],'desc')=2 (which would be max when this statement is true), like this:

 

ValueFormax(DenseRank([timeperiod],'desc')=2,[timeperiod])