lay out your marks are shown here: Using Measure Values allow you to share the second axis and use lines as a mark type separately from the points.
RateTabPack.twbx 37.7 KB
Thank you! This is great!
For the benefit of others who may try to do this, below is a description of how I made the changes. I applied this to my more-complex version, and had a bit of trouble at first.
As I looked at your example I found #Measure Values under the list of Measures in the left pane, so dragged that over to marks and removed what I didn't need.
Then it was still showing as separate graphs, but I saw that the row pills in your example each had straight edge where they meet, so I right-clicked on the Measure Values pill and clicked the Dual Axis option.
Now I have all three lines and the scatter on one chart! The next issue was the % lines appeared inaccurate, but then I noticed the right and left axes had very different ranges. I right clicked on the left axis and clicked Synchronize Axis. Since the 5% line was way above all my values, it made the scatter too small and didn't seem relevant anymore, so I removed that line.
I also noticed that the tooltips are different for the Measure values versus Rate 1000cf. I don't mind, because it is displaying exactly as I would like. I didn't know we could have different tooltip templates for different measures. I like that feature. One other thing, in the left pane under Marks it says Sum(Rate 1000cf), which I find odd because it's just the values, not aggregate/sum. Again, I don't mind because the graph is as it should be.
I forgot to mention in the last post that I am using Desktop Version 10.2.1
Thanks again for the help!