Does Sheet3 work? I've created a dual axis with the two calculations that you had created, and place eventID on the filter shelf, excluding all values but eventX and eventY.
Hope this helps!
Sample-TF.twbx.zip 30.4 KB
Thank you for response! Excluding the values in filter wouldn't really occur to me Can you explain why it works this way (and why the line graph for event x doesn't work just by placing the two calculations in the rows shelf - i.e., why we need to use the filter).
This might work, but I was wondering if there is a way to connect every point on the Event X (making it really continuous instead of broken by the Event Y values)?
Thanks again. I really appreciate it.
I have a similar question; however, I am trying to overlay #Events and Sales for each month over the past two years. I tried mirroring your calculated field; however, Tableau keeps giving me an error "Can't compare date and string values". Any ideas on how to fix this issue?
Thank you in advance for your help!