Here's an elegant solution to ranking. It assumes that you have a Table, e.g., "Users," with a field with some value, e.g., "CLV," and an empty numbers field, e.g., "Rank."1) Create an automation trigger to run the script, e.g., When a record is crea...

If you want to, for example, count the number of dates (or any data by the number of entries) in a lookup field, this works:COUNTALL(ARRAYUNIQUE({your_date_field}))