Would it be possible to post a sample workbook (twbx file) showing this so that I can take a closer look?
Hi Tracy -
My data is confidential, so I recreated a small random data set, exactly how the 2 particular fields were, and how I generated the calculated field etc. and of course what do you know, murphy's law, it behaves the way I want it to!
something is different in my 2nd graph that may be interfering.
Anyway the sampe data set/file (which works) is attached. Thanks for offering to help.
Hope something suggests itself to you as advice, to me.Thanks again
Here's the VERY SAME same data tweaked only to make 2011 a bit smaller, and Div "A' also trimmed alongside.
But when I re-did the graph, I'm having my original problem!!! - the 2nd dual axis now does NOT offer me 2 options for the reference lines?? Also yesterday's file was giving me a "Swap reference lines" option on the 2nd axis, now it does not!!! Very puzzling on what the difference is...between the 2 types of data settings Any help will be appreciated!
(I had thought that my original problem was because I was using blended data from 2 different data sets in that workbook, though the measures in the graph in question itself were from the same data source - but this SAMPLE data sets where 1 works and the other does not, rules out the blended data as being the problem - that's at least good to know for now.)
Addiitonal info - I did do a filter on the excel file of the 2nd sample (to revise some data points and make it look reasonable) - which is the only difference between the 2 raw excel sample files which were imported into Tableau.
But my real file where the reference line worked also used filtered data...so...just throwing that in...
I'm unable to open your workbooks, can you repost them and make sure to save them as twbx files? Thanks!
Hi Tracy -
Sorry about that - still getting used to the Tableau file name-extns...
Here are both files - the first worked (with reference lines on 2nd axis based on 1st axis values)
the second only offers 2nd axis reference lines based on its own values...
Hope these illustrate the problem adequately.
Thanks very much for helping!
It looks like a couple of things are happening here. First, in the Sample Bullet Dual Axis not working, the axes are not synchronized. The Sum(Tot_A) axis's values are in the thousands whereas the Sum9TotCompany) is in the billions. Second, the sum(TotCompany) needs to be placed on the Level of Detail shelf so that it can be referenced in the reference lines/distribution lines. Also, another difference between the two workbooks is that the reference lines are being added by cell in the working workbook, and by pane in the workbook that is not working. Let me know if this information still doesn't help resolve your issues, hope it helps!
You got it! I wouldn't have figured it by myself -
Looks like the key thing is to have had the 1st axis in the Level of Detail shelf - whether or not the 2 axes are synchronized. In fact if they are synchronized then I wouldn't have the need to use the reference line as a crutch to translate the 2 axes - because they are on different scales and I wanted my users to be able to have a handy slide-rule type of scale, I found this application of the reference line useful!
So its important to have the 1st axis on the Level of Detail shelf, when trying to get the 2nd axis to reference the 1st.
Thank you SO VERY MUCH Tracy!!