Can you explain what you mean by 'my data model is wrong?'
The structure of my data is the following: I have an excel spreadsheet with three tabs for portfolio, capital projects and building data. Within those tabs are datapoints that are specific to that tab as well as shared across the other two tabs.
What I mean by "goofish" was really supposed to be "goofy" but lets say I am under the building data that has every piece of information about that building. If I click on 'address', which is one of the columns, it shows up on the map. But if I add 'state" then everything disappears. Another example is that I have square footage for evey building but it keep calculating the total square footage of all of the buildings in the spreadsheet.
How can I import the spreadsheet in a manner where I can see where all of my buildings are on the map and have the ability to drill down into each building and see things like that building square footage, lease terms, and capital projects associated with that building. Note, all of that data is associated with a specific building in the spreadsheet.
