Skip to content
Advertisement

Using rank to enumerate the session

Hi can anyone help me for this. What im trying to do is to rank my session id but it seems not to work as it returns me just “1”. The third row should be 2, the row 5 should have 2 for rank and the row 6 should have 3 for rank and so on. I try to enumerate the session. Thank u so much

enter image description here

Advertisement

Answer

Presumably, you want:

This ranks hits within groups having the same visitor and session by ascending timestamp – which is how I understand your question.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement