
1. Re: Plotting Points on a Circle  Network/Hub & Spoke Graph
swaroop.gantela Oct 29, 2018 6:20 PM (in response to Liz Lucabaugh)1 of 1 people found this helpfulLiz,
Not sure if you had already seen this, or if you've already moved past it,
but here is an excellent blog post from Ken Flerlage:
Introducing the Snowflake Chart  Ken Flerlage: Analytics Architecture, Strategy, & Visualization
Answered example by Ken :

2. Re: Plotting Points on a Circle  Network/Hub & Spoke Graph
Ken Flerlage Oct 30, 2018 5:55 AM (in response to swaroop.gantela)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.

Radial Test New.xlsx 8.6 KB

Radial.twbx 22.8 KB

3. Re: Plotting Points on a Circle  Network/Hub & Spoke Graph
Ken Flerlage Oct 30, 2018 6:00 AM (in response to Ken Flerlage)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.

Radial.twbx 30.0 KB


4. Re: Plotting Points on a Circle  Network/Hub & Spoke Graph
Liz Lucabaugh Oct 30, 2018 8:12 AM (in response to Ken Flerlage)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
Liz Lucabaugh Oct 30, 2018 8:12 AM (in response to Ken Flerlage)I love that idea  thank you!!!

6. Re: Plotting Points on a Circle  Network/Hub & Spoke Graph
Ken Flerlage Oct 30, 2018 8:40 AM (in response to Liz Lucabaugh)Great. Glad it helped!