How to apply a filter to multiple tables?

[pandakillsalot]

Hi, all.

I got two tables which nearly have the same columns. And both the column name, data type are the same.

I am trying to put them together on a chart. However,  it seems that number is always wrong for the second one.

For the "Overall pass table", I did a distinct count and the number I get should be around 100, not 100k. I guess's either the date filter not working or the part number is not working.

(PS. I linked the two test date and  part number column together)

[mgallacher]

By "link" do you mean created a relationship? The two tables of data have to share a common value to create a successful relationship. 

[pandakillsalot]

Sure, I create links both for the column test date and the column part number.