How do I identify the second lowest value? I.e. MIN('COLUMN') +1?
I'm trying to sort my API calls by time and label the order in which they took place, however I'm not sure how to identify beyond the MIN time. Is there a way to identify the MIN and then look at the second or third or fourth value thereafter?
Ideally, my Beast Mode would then label each call with the order they came in by date and user.
MIN('TIME') THEN '1'
MIN('TIME')+1 THEN '2'
MIN(*TIME')+2 THEN '3'