Creating Ranks in script editor using Auto number for tied values and then skipping the next rank

[DKK]

Hi All

I was trying to creating the ranks  for the following data as follows but some how its not giving the right results by using Auto number function. output required for ranks should be something like ( 1,2,2,4,5,6,6,8)  and attached is the excel file for reference. Any advise or help is highly appreciated.

Regards

Kiran

[Arthur_Fong · Accepted solution]

There you go:

Split the fact table into Regions and apply rowno() to get numRow column for each regions.

Then, concatenate all Regions table into one.

Finally, use both fields to check if the autonumber Rank field is repeated using peek() function.

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

[DKK]

Hi Arthur,

Thank you so much for the response and it worked like a charm.

Regards

KD