-
1. Re: Forcing Synchronize dual axes
Emily, try going to the far right axis and synchronizing that one (it should be available, I think).
--Shawn
-
2. Re: Forcing Synchronize dual axes
For some reason, it is not available. Thought maybe there was a way to force it, or maybe a setting I am missing to allow it.
-
3. Re: Forcing Synchronize dual axes
Emily, well you can use 'Fixed Axis'. By rt-clicking and choosing 'Edit Axis'. You'll get this dialog box:
Set both of the dual axes to the same range and you'll force sync. But the down-side is that this does not change dynamically. Hope this helps.
--Shawn
-
4. Re: Forcing Synchronize dual axes
Tracy Rodgers
Mar 6, 2012 1:42 PM
Hi Emily,
If the two measures on your view do not have the same data type, then you will not have the option to Synchronize Axes. It is not possible to mix floats and integers, they need to match. Therefore, check your data types. Hopefully, this will solve the issue!
-Tracy
-
5. Re: Forcing Synchronize dual axes
Thanks Shawn- I need it to dynamically change with each supplier's information, so I don't want to fix the axes.
Tracy- The 2 measures are both numbers. 1 is a calculated field, does that make a difference?
-
6. Re: Forcing Synchronize dual axes
Tracy Rodgers
Mar 6, 2012 2:03 PM
Emily, would you be able to post the workbook or a sample workbook (saved as a twbx file)? Thanks!
-Tracy
-
7. Re: Forcing Synchronize dual axes
Thanks for looking at this. Let me know if you see anything I am missing.
-
8. Re: Forcing Synchronize dual axes
Tracy Rodgers
Mar 6, 2012 2:49 PM
Hi Emily,
Though both fields are both numbers, their exact data types are slightly different. Projected *1000 is a float, while Actual lbs is an integer. To get around this, simply create a calculated field that changes one or the other so that they match. For example, create a calculated field that looks like the following:
float([Actual lbs])
Place this calculation on rows shelf in place of Actual lbs. Then, you will have the option to synchronize the axes.
-Tracy
-
9. Re: Forcing Synchronize dual axes
Thank you that worked! Sorry I couldn't figure this out on my own. How do I find the field properties in the future, so that I don't make this mistake again? I tried right clicking the measures, but that just told me it was a number.
-
10. Re: Forcing Synchronize dual axes
Tracy Rodgers
Mar 6, 2012 3:39 PM
Glad you got it working! One way to check to see what data type Tableau is recognizing a field as is to open the calculated field box, select the desired field and in the yellow box at the bottom right will tell what type of field it is.
-Tracy
-
