9 Replies Latest reply on Nov 28, 2018 5:30 PM by swaroop.gantela

# Plotting Points on a Circle - Network/Hub & Spoke Graph

Hi Everyone,

I'd like to attempt to create a network graph, hub and spoke style, for my team. The idea is to create a visual showing all 18 team members (the spokes) connected to one arbitrary data point/circle representing the team name (the hub). You should clearly see the path lines from each team member to the hub. My question here is how can I meticulously plot each team member so that they are even distance apart from the inner circle? Can each member have its own circle/lollipop as an overlay onto the outer circle? I realize this requires some geometry but not sure where to start.

Bonus: I'd also like to incorporate "tenure" or length of time each team member has been employed. To illustrate this, I'd like for the path length to represent tenure - the longer the path, the longer the employee has been on the team. Is this possible?

Bonus Part II: Would it also be possible to overlay a headshot of each team member onto the data point that represents them?

Thanks!!!

• ###### 1. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

Liz,

but here is an excellent blog post from Ken Flerlage:

1 of 1 people found this helpful
• ###### 2. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

Thanks for the mention, Swaroop!

This method would work, but it may be a bit complicated as it's meant for a hierarchical hub and spoke chart. If you just have a single hub with multiple spokes and wish to automate the calculations, then we can use a bit of trig for this. For more on how to use trig in Tableau, I'd recommend reading Beyond "Show Me" Part 2: Trigonometry - Ken Flerlage: Analytics Architecture, Strategy, & Visualization

First, you'll need to union your data to itself. Your data has already duplicated each person, so I suppose that's not necessary, but I like the union approach because it doesn't require you to duplicate the data manually. Your data could be as simple as this (see attached):

 Spoke Tenure Hub Team Lucy 12 DS Kendra Kendra 15 DS Kendra Rob 8 DS Kendra Shirley 9 DS Kendra Lisa 26 DS Kendra Addison 120 DS Kendra Noy 30 DS Kendra Emma 49 DS Kendra Jonathan 80 DS Kendra Andre 71 DS Jeff Chad 60 DS Jeff Jeselyn 55 DS Jeff Jeff 33 DS Jeff Jake 46 DS Jeff Meghan 57 DS Jeff Liz 7 DS Jeff Archana 23 DS Jeff Kenyan 8 DS Jeff

I won't go through all of the calculations here, but basically, here's a quick breakdown of the calcs with an explanation of each.

• Total Team Members - Total number of team members. We'll need this to ensure even angle spacing.
• Angle Spacing - Angle spacing between each node/spoke.
• Angle - Calculated angle for each node.
• X Calc - Calculated x coordinate based on the radius (tenure) and the angle.
• Y Calc - Calculated y coordinate based on the radius (tenure) and the angle.
• Size - Used to size the hub and nodes.

In the end, you'll get something like this. See the attached workbook for more.

1 of 1 people found this helpful
• ###### 3. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

One other thought. Instead of the length of the line representing tenure, perhaps you could size the bubbles instead. That would create a more organized look, while still visually encoding each person's tenure.

1 of 1 people found this helpful
• ###### 4. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

Brilliant! This is very helpful and just what I was looking for. Thank you!

• ###### 5. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

I love that idea - thank you!!!

• ###### 7. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

Hi!

I had just a couple of follow-up questions on this graph:

• I'd like to color condition each employee's "team" (by dragging the "team" field to the color icon on marks card) but the end result looks odd (see below). Not sure what's going on in the data to make it so "one-sided" but would love to figure out how to solve for that.
• Also, any change you know how to add/overlay individual photographs on each of the circles for corresponding spokes?

Thank you!!

• ###### 8. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

chance* not change.

• ###### 9. Re: Plotting Points on a Circle - Network/Hub & Spoke Graph

Liz,

You can add the team name to color, but I think you will

need to add it as an Attribute so that it doesn't affect the table calculation settings.

(I think you'd like both [Table Name] and [Team] on the color shelf. You can

do so by control-clicking both dimensions and dragging them to the color shelf,

or add [Team] to the Detail shelf and the click on the icon to the left of the [Team]

pill and change it to color).

It might be possible to add all your images as shapes and then assign

the corresponding shape to each spoke. See sheet "image" of the attached

workbook v10.4 attached in the Forum Thread.