rank fun

[vignesh_s]

i have 2 9's so im geting 2-3 and 2-3 as rand, for 8 i got 4 ,so i should get 3 as rank for 8,can i get the expression for tat

[devarasu07]

Hi,

Check stalwar1‌ Solution,

Continuous Ranking (no missing Rank)

[zhadrakas]

cou could try this:

Rank(total aggr(Rank(concat(String&ID)), ID))

eventually you Need to uncheck "hide null values" in presentation tab

[vignesh_s]

i wanna display that value too

[zhadrakas · Accepted solution]

there is definitely a better way to do it but you could use this expression

if(isnull(Rank(total aggr(Rank(concat(String&ID)), ID))),
above(Rank(total aggr(Rank(concat(String&ID)), ID))),
Rank(total aggr(Rank(concat(String&ID)), ID)))

[vignesh_s]

thank you