Adding Ranking to objects - how to achieve this

[Anonymous]

I have to add Rank to charts and graphs ordering value from large to small. How to achieve this? Please reply.

[Anonymous]

Hello Trail, there are a lot of ways to do this, how is your data?

[prat1507]

You can use Rank() function or in the Sort tab you can sort by expression.

Regards

Pratyush

[Anonymous]

Hi Pratyush, can you kindly tell me where to best use the Rank function sharing the syntax as well.

[prat1507]

Sure, you can use rank function to sort your chart, as well as give ranks to the dimensions basis any expression.

For. ex.

If your data is something like this

Student,Marks

Auro, 100

Ben, 30

Charles, 40

Dan, 70

and use a simple straight table

where you can use dimensions as Student, and get the ranks based on their Marks

using expression rank(Sum(Marks))

This will return

Auro 1

Dan 2

Charles 3

Ben 4

I hope you understand.

Regards
Pratyush