I have a set of log data that is basically in this format:
Event timestamp user
6 10/14/2019 1:29 User1
33 10/14/2019 1:30 User1
3 10/14/2019 1:30 User1
6 10/14/2019 2:12 User2
36 10/14/2019 2:12 User2
31 10/14/2019 2:27 User2
I don't have the required source and target columns in the logs, so I'm not quite sure how to approach creating a Sankey diagram. I have a "login" event that I can use as the starting point to figure out what users are doing. How can I get from the log files I have now to a format that the Sankey diagram can use? Do I need to edit the files to create a source and target field?
For example, I'd like to take the example data from above, and turn it into the following Sankey-friendly format:
User Source Dest
User1 6 33
User1 33 3
User2 6 36
User2 36 31
... View more