Trying to join three data cuts into one chart

Hi there. I have a set of policy data that goes back a couple of years. I have a scatter chart that shows currently live policy data, however, I am trying to also add in a view of 'live last quarter' and 'live last year' into the chart. I thought I could just connect to my source 3 times and add in a SQL where to be:

• Currently Live: where [Start Date] <= '1/1/23' and End Date > '1/1/23'
• Live Last Quarter: where [Start Date] <= '10/1/22' and End Date > '10/1/22'
• Live Last Year: where [Start Date] <= '1/1/22' and End Date > '1/1/22'

and then toss them into the scatter plot, but this did not work!

I added in some relationships between the three at the ID level, but still giving me errors. Is there a better way of doing this (that actually works!)

Thank you