-
1. Re: Forcing Synchronize dual axes
Shawn Wallwork Mar 6, 2012 1:09 PM (in response to Emily Mueller)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
Emily Mueller Mar 6, 2012 1:10 PM (in response to Shawn Wallwork)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
Shawn Wallwork Mar 6, 2012 1:21 PM (in response to Emily Mueller) -
4. Re: Forcing Synchronize dual axes
Tracy RodgersMar 6, 2012 1:42 PM (in response to Emily Mueller)
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
Emily Mueller Mar 6, 2012 1:58 PM (in response to Tracy Rodgers)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 RodgersMar 6, 2012 2:03 PM (in response to Emily Mueller)
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
Emily Mueller Mar 6, 2012 2:35 PM (in response to Tracy Rodgers)Thanks for looking at this. Let me know if you see anything I am missing.
-
Milk Projections packaged.twbx.zip 597.6 KB
-
-
8. Re: Forcing Synchronize dual axes
Tracy RodgersMar 6, 2012 2:49 PM (in response to Emily Mueller)
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
Emily Mueller Mar 6, 2012 3:14 PM (in response to Tracy Rodgers)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 RodgersMar 6, 2012 3:39 PM (in response to Emily Mueller)
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
-
11. Re: Forcing Synchronize dual axes
Emily Mueller Mar 7, 2012 7:12 AM (in response to Tracy Rodgers)Thanks for all the tips!