WHy is this Rank function used ??

[nikhilgarg]

HEy,

WHy is this Rank function used ??

Just for ranking the values from high to low? Is it so ?

Thanks

[Gysbert_Wassenaar]

The rank function is used to calculate the rank of a value in a list of values returned by an expression. See the help file for details.

[its_anandrjs]

Hi,

Rank function is use to give Rank to the expression or Metric values

Ex:-

LOAD * INLINE [

    Item, Sales

    A, 500

    B, 300

    C, 100

    D, 150

    E, 600

];

If you create the straight chart

Dim:- Item

Expre:- Sum(Sales)

Expre:- Rank(Sum(Sales))

By this you can rank the expression

And when you get this details you can find min or max values or Top N values.

Regards

Anand