5 Replies Latest reply on Oct 24, 2018 6:51 AM by Gerardo Varela

# how to create the parallel coordinates as demonstrated by Joe Mako

Thank you!

• ###### 1. Re: how to create the parallel coordinates as demonstrated by Joe Mako

The main formula in Joe’s example is his norm formula:

(MIN([Measure]

)-TOTAL(MIN([Measure]

)))/(TOTAL(MAX([Measure]

))-TOTAL(MIN([Measure]

)))

So from the sample store data let’s make a copy of Sales and edit the formula as so:

Do the same for profit and quantify.

Now drag measure names to the columns shelf right click -> edit filter.  Let’s just keep the copies we created earlier.

Now drag measure values to the rows shelf and then Order ID to the details shelf. You’ll get a nice bar chart.  Let’s change the bar to a line.

Now we start to see the wizardry behind Joe’s mind.

Let’s add some color. Drag measure values to the color shelf and edit the color.

Now let’s adjust the line size.

I hope this is enough to get you started!

Regards,

Gerardo

1 of 1 people found this helpful
• ###### 2. Re: how to create the parallel coordinates as demonstrated by Joe Mako

Dear Gerardo, Thank you very much for the detailed explanation!

I created a simple example with the steps illustrated on Tableau Public:

My understanding is that the calculated field created for each measure variable using Joe Mako's formula is to "normalize or map" the different values of that variable on to a scale of 0 to 1, with the minimum value been mapped as "0" and the maximum value been mapped as "1" and each of the rest values is give a value between 0 to 1 proportionally.

Thank you, again!

• ###### 3. Re: how to create the parallel coordinates as demonstrated by Joe Mako

You got gist of it.  Best thing about these workbooks is taking them apart and putting them back together.  I hadn't seen Joe's workbook until you posted your question, so thank you.

If you really want to know what the formula is doing break it down to it's single parts. If you need more help please post back.

Regards,

Gerardo

1 of 1 people found this helpful
• ###### 4. Re: how to create the parallel coordinates as demonstrated by Joe Mako

In newer versions of Tableau you can also use Level of Detail expressions for rescaling the measures. E.g.,

([Acceleration]-{MIN([Acceleration])})

/

({MAX([Acceleration])}-{MIN([Acceleration])})

• ###### 5. Re: how to create the parallel coordinates as demonstrated by Joe Mako

You are correct.  Shortly after version 9.0 came out Jonathan Drummey created this blog post:

Regards,

Gerardo