2 Replies Latest reply on Jul 20, 2016 4:14 PM by Adam Borenstein

# Connecting Large Network Map

I have a large network map with connections between many vertices.

As of right now I have a list (excel sheet) of individuals in the map (their vertex has coordinates) and a separate list of their connections in an excel sheet (one column shows vertex 1, other is vertex 2, the connection would be between vertex 1-> vertex 2).

Currently I have unionized the two sheets to match based on each individual's ID and the first vertex (vertex 1) in the connection, and created a calculated field called "connections" ([Vertex ID 1]+"->"+[Vertex ID 2]) to draw the lines between points. This formula was given to me by someone else and I don't understand how the +"->"+ operation works.

I am running into two problems. One is that some connections are described as the reverse (Vertex ID 2->Vertex ID 1) and wouldn't show up with the map I have currently. But more importantly, the map connections are coming out "linear", in that each individual point only has two lines drawn to it, which are the line connecting them to those with consecutive ID numbers (i.e. person with ID 100 is connected to ID 99 and 101, but no one else)

How can I integrate these two sheets of data in tableau to show all relationships between each person in the map?

• ###### 1. Re: Connecting Large Network Map

Do you have sample data that can be shared (ideally in a Tableau .twbx file) with the community so we can see the details here to assist.

Also - what version of Tableau are you currently utilizing?

Thank you

Patrick

• ###### 2. Re: Connecting Large Network Map

Hi Patrick,

Thanks for taking a look at my post!

As it happens I solved this by following the structure given in the link below, and then modifying it to suit my needs.

In Chaos, Clarity: Social Network Diagrams in Tableau | Tableau Public

I also mistakenly signed up for two accounts, but I do have other ongoing questions that have been posted with my alternate account. If you have the time maybe you can help me out there ->Adding Specificity to Filters . Though it shows the question as answered I have added additional follow-up questions.

Thanks!