Cannot Sync Axis In Tableau?

Question

I'm new to Tableau Software. I have version 8.2.3 installed. I'm trying to create a Network Chart via the example at:

http://www.clearlyandsimply.com/clearly_and_simply/2012/12/build-network-graphs-in-tableau.html

It seems simple enough. They even provide the sample Excel workbook at:

Download Network Graphs Example Data (Microsoft Excel 2007/2010, 14.3K)

As I go through the example everything seems fine till I get to the part where it says:

---

Step 2 – Dual Axis

Add the “Circle Y” to View on the rows shelf as a double axis, and synchronize the two Y axes (right-click on the axis, and click on “Synchronize axis”).

---

For some reason, the "Synchronize Axis" option is greyed out (disabled). I Googled and an article said that it might be because the data types are different. So I created calculated fields as they said but that didn't work.

Does it seem that no matter what I do the "Synchronize Axis" option will not enable? I'm not sure what I'm doing wrong.

Can anyone help me with this? I have a project due on Monday and really need to get this example up and running.

Answer 1

• This occurs due to the data types on each axis are different. You can use INT() and FLOAT() on calculated fields in tableau to convert data types, or CAST with SQL to match data types.

• AVG() will most likely produce a float and COUNT() will most likely produce an integer when using calculated fields in tableau.