Clever Geek Handbook

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!

+3


source to share


3 answers


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.

+3


source


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

+2


source


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.

+1


source






More articles:


All Articles