Forum Discussion
Using RankX with several columns
I have three columns that I want to use as input for a ranking (analysis of beacon data). This is what I have (heading in black), and what I want to create (heading in red): Timestamp rank (be...
One point to clarify, according to your rules, shouldn't Timestamp rank 2 create a new rank in your calculation since the timestamp difference is 4 hours?
Hi smoupre - Thanks for your question.
The "timestamp difference" I created is the difference between the timestamp-value for the next rank (column A) and the timestamp value for the current row. Based on this, the next rank in the calculation should be given to rank+1 if the difference is over 3 hours.