How to figure out which data is missing

[Niels_T]

I have data about countries, orders and sales.

The thing is that I notice that there are certain orders and sales that miss the country data:

I use two tables for this:

1. Address table

2. Order table

I think the problem might be in the order table.

What is the best way to go about this process? 

I've already checked different relationships, but everything should be perfectly fine with my relationships.

I was thinking about putting the country column next to the columns of the order table and through this way search for a blank value, but I have no idea how to do this.

[mahoneypat]

In the Data View, look at the two tables.  Highlight the Country column and see the distinct count of values at the bottom on both tables.  Do you see the same #?

Pat

[Niels_T]

Hey @mahoneypat,

It seems like they do not have the same #.

The country table and the entity id column which is connected with the order table has #2950 distinct values

The billing_address_Id of the order table contains 3636#. 

So it seems that there is missing data in the address table and therefore they cannot specify it?

[FarhanAhmed]

Use countries from both tables (Sales & Country) in that way you will identify which countries or country is not mapped

[Niels_T]

Thank you for the quick reply. How am I able to put the country column next to the columns of my order table?

[FarhanAhmed]

if possible can you please share the data model of your report?

you need to check how is your country & Sales data is join..

Put those key values in Table or Matrix to view data of both tables against each other.

[Niels_T]

I have put the tables next to each other. The thing is it looks like the data is complete:

Yet in my table it shows that there are countries missing.

Could there be another reason why this is the case?