saved search formula rank where rank starts at 1 and each rank is unique

AI generated answer (using internal Slack threads):

In order to create a saved search formula where each rank starts at 1 and each rank is unique, you can use the

DENSE_RANK()

function in your formula. This function will assign a unique rank to each unique value in the order of the results. Here is an example of how you can use it:

DENSE_RANK() OVER (ORDER BY {internalid} DESC)

In this example, the formula is ordering by the internal ID in descending order. The

DENSE_RANK()

function will assign a unique rank to each unique internal ID. If you have multiple lines with the same internal ID, they will all receive the same rank. Please note that the field you order by in the

DENSE_RANK()

function should match the order of your search results. If your search results are ordered differently, you should adjust the field in the

DENSE_RANK()

function accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******