Using RankX with several columns

[audune]

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 (because of duplicates)	Timestamp difference (next timestamp)	Area	Rank I want to create
1	1 min	Area 1	1
1	1 min	Area 1	1
2	4 hours	Area 1	1
3	20 min	Area 1	2
4	20 min	Area 3	3

The rule is; the rank should change if the timestamp difference is > 3 hours OR if the area changes.

Can anyone help me with this?

Thanks

[Greg_Deckler]

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?

[audune]

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.