Combining datasets

[Anonymous]

Hi community members!

I have another question;

I have two data sets 

One dataset provides information on the number of building our company rents and the contract costs for various contracts. The other dataset tells me how many people (FTE) work in each building and the square meters per building. 

Now I want to make a visual thats tells me the contract costs (of the first dataset) per square meter or FTE. 

How can I create such a visual? 

Hope to hear soon from you! 

Cheers Sander

The Netherlands

[parry2k]

@Anonymous share sample data in excel and will get you the solution. The idea is you need to create a building table with unique values and link that table with contract cost and FTE table, once it is done, evertyhing from there will be super easy.