I am trying to organise some web browsing data to put into a sankey.
It looks like this:
User | Date | Action |
Person 1 | 30/04/2024 00:00 | Novo Nordisk Lcs 009 (2) En Final (1) |
Person 1 | 01/05/2024 00:00 | Novo Nordisk Lcs 009 (2) En Final (2) |
Person 1 | 03/05/2024 00:00 | /home |
Person 2 | 03/05/2024 00:00 | /home |
Person 2 | 03/05/2024 00:00 | Let me introduce you |
Person 2 | 03/05/2024 00:00 | Let me introduce you |
Person 2 | 03/05/2024 00:00 | /home/new-leaders-connect |
Person 2 | 03/05/2024 00:00 | /home/new-leaders-connect:nlc-collection |
I want a new column which shows the next page they navigated to, ie, the value held in the 'action' field from the next row, such as
User | Date | Action | next action |
Person 1 | 30/04/2024 00:00 | Novo Nordisk Lcs 009 (2) En Final (1) | Novo Nordisk Lcs 009 (2) En Final (2) |
Person 1 | 01/05/2024 00:00 | Novo Nordisk Lcs 009 (2) En Final (2) | /home |
Person 1 | 03/05/2024 00:00 | /home | |
Person 2 | 03/05/2024 00:00 | /home | Let me introduce you |
Person 2 | 03/05/2024 00:00 | Let me introduce you | Let me introduce you |
Person 2 | 03/05/2024 00:00 | Let me introduce you | /home/new-leaders-connect |
Person 2 | 03/05/2024 00:00 | /home/new-leaders-connect | /home/new-leaders-connect:nlc-collection |
Person 2 | 03/05/2024 00:00 | /home/new-leaders-connect:nlc-collection |
Any thoughts? :)
@DKMI use the multi-row tool for your use-case