Hi, I need to do some analysis on access permissions of an application.
I want to graphically show the relationships of users and the access they have. I have a simple data set like the format below (I have a much bigger dataset):
I would like to answer the question:
Of the users who have access to a specific folder, say "Apple", what other folders to they have access to and what are the associated volumes with that connection.
I was thinking Sankey diagram but I am having trouble getting the data in the right format. Any help would be really appreciated.
UserID | Folder |
1 | Apple |
1 | Banana |
2 | Apple |
3 | Apple |
3 | Orange |