1 of 1 people found this helpful
The main formula in Joe’s example is his norm formula:
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!
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.
Please kindly advise if I understand it correctly.
Thank you, again!
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.