Can't sync axis in table?
I am new to Tableau software. I have version 8.2.3 installed. I am trying to create a network diagram in the following example:
http://www.clearlyandsimply.com/clearly_and_simply/2012/12/build-network-graphs-in-tableau.html
Seems simple enough. They even provide an example Excel workbook at:
Download Sample Network Graph Data (Microsoft Excel 2007/2010, 14.3K)
When I go through the example, everything seems fine until I get to the part where it says:
Step 2 - Dual Axis
Add a Y-circle for double-axis viewing on the shelf and synchronize the two Y-axes (right-click on the axis and click Synchronize Axis).
The Synchronize Axis option is grayed out (disabled) for some reason. I Googled and the article said it could be because the data types are different. So I created calculated fields as they said, but it didn't work.
It seems that no matter what I do, the "Synchronize axis" option is not enabled? I'm not sure what I am doing wrong.
Can anyone help me with this? I have a project on Monday and really need to run this example.
Thank you, thank you very much!
This is because the data types on each axis are different. You can use INT () and FLOAT () on calculated fields in a table to convert data types, or CAST to SQL to map data types.
AVG () will most likely produce a float, while COUNT () will most likely produce an integer when using calculated fields in a table.
I also had this problem and talked to her. I was able to fix this by casting both series as int with INT () or FLOAT (). Since doing one didn't work, I would try casting both fields. Another thing to try is reordering the pills and then try again. Sometimes it works strangely.
http://onlinehelp.tableausoftware.com/current/pro/online/mac/en-us/functions_functions_typeconversion.html
If you right click on the y-axis on the right side and select "Fixed" instead of "Automatic" and set a range that exactly matches the original y-axis, it will align well.