7 Replies Latest reply on Jun 20, 2016 12:00 PM by Michael Hesser

Well first it was created a long time ago in 8.0. But the big swirl is actually a background image. Delete it and here's what it looks like:

Everything else is just a custom shape given an x/y position. A bit of work, but not all that complicated.

--Shawn

Yea that's what I was trying to figure out. How do you figure out the x/y position?

Sent from my iPhone

I suspect it's just an Excel spreadsheet that produces those positions. I'm sure there is some sort of math formula that produced the x/y values, but I'm not a math guy so I don't know what that formula is. Maybe Richard Leeke knows.

Cheers,

--Shawn

ok thanks, yea I don't even know where to start.

On Wed, Jun 15, 2016 at 6:18 PM, Shawn Wallwork <

Hey Shawn,

Maybe you can help me with this follow up question. Say you did this same

thing but instead of just california on one chart, you had Oregon and

Washington side by side with the same graphics. So it would be the same

departments but it the data could be set up like this:

California, Agriculture, x position, y position

California, Economic Development, x position, y position

Oregon, Agriculture, x position, y position

Oregon, Economic Development, x position, y position

Washington, Agriculture, x positon, y position

Washington,  Economic Development, x position, y position

The problem is you can't use Avg , Avg (y) on the columns and rows, as

it will only show the center circles. However I would want to show circles

like the following example for all three graphs (california, Washington,

Oregon) on one worksheet.

Does that make sense? How would you do that?

Thanks,

Brook

On Wed, Jun 15, 2016 at 6:18 PM, Shawn Wallwork <

Hi Brook,

You could use Alan Etheridge's jittering technique to plot the X and Y values.

Jittering

Alan has an awesome blog:

The Last Data Bender | Musings on Tableau from the last of the data benders.

Here are some more blog posts about jittering:

I’ve Got the Jitters (and I Like it!) – Data Revelations

https://www.dataplusscience.com/TableauJitter.html

Tableau Zen: Improving Jitter plots with the hidden RANDOM() function in #Tableau

Attached is example that doesn't include the custom shapes, vs 9.3.  I hope that's enough to give you some ideas.  I'll just mention that this isn't visualization "best practices" but I found to be a nice learning exercise.

Regards,

Gerardo