Ranking in ascending order

[raghavsurya]

Hi All,

I have a requirement wherein I have to do the ranking of values in ascending order.  For Example lower the values, higher the rank. 

Value    Rank

1           1

3             2

8             3

10           4

Can you please suggest how to use the Rank function to get the desired result.

Regards,

Raghav

[Anonymous]

Do you see the column "4 år" that ranking starts with 5 and forth

[Anonymous]

..and here's the screenshot 😃

[Anonymous]

i did solve the "not-starting-rank-from-one"-problem by using this expression instead;

rank(aggr(((sum(rate)*-1)),name,TimeName),0,1)

but now i still have a dynamic higest rank number that i need to higlight some how.

[kaushiknsolanki]

HI,

   Try this.

   Click + button at rank expression.

   Change the text color or the background.

Regards,

Kaushik Solanki