Liz,

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 :

How would I make a bubble chart like this???

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):

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.

Great. Glad it helped!

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.