Public Google Data Connection, Model Tab not working as Expected

Here is another way of looking at it - this is whats happening atm (note the red cells):



It seems as though the connection is working, because the data is filtered accross the two tables.

But its doing so incorrectly. Because its saying both agents have the Time-Off, when the input value only says 1 does.