Rank

[Luben]

Hello could anyone please help explain how Rank Function in load script editor works.

is it the same as in SQL

[JordyWegman]

Hi Luben,

There is no Rank() function for the script, it's only a function for charts. What would you like to accomplish?

You can use RowNo() for instance to give a number for each row, more rank like.

Jordy

Climber

[Luben]

hello Jordy, thanks for your response.

here is what i am trying to do below i have use RowNo() and autonumber of the Booking number filed to give it a unique number.

the goal is to filter out all bookings with rank 1.  The problem i am facing is using this on the load script on 1m plus rows it takes over 40mins to load. is there a better way for me to filter the data to get bookings with the number 2.

Thanks

[JordyWegman]

Hmm.. I'm not sure about this. Because wouldn't this cause to give it an unique number.. so you're left with only one 1 and one 2 right?

Based on what logic should the ranking work? When is it a number 2?

Jordy

Climber