1 of 1 people found this helpful
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:
Answered example by Ken :
1 of 1 people found this helpful
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.
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
Brilliant! This is very helpful and just what I was looking for. Thank you!
I love that idea - thank you!!!
Great. Glad it helped!
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?
chance* not change.
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.
286199spoke.twbx 76.6 KB