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? :)
