analysing/visualising one to many relationships

Splunk User Behavior Analytics

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

Get Updates on the Splunk Community!

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...