I've spent hours on this and still can't figure it out!
I am pretty convinced you can't do this with blended data blended data works at the aggregate level of the link
Sarah is the expert - if it can be done she will know
I have done something like this but not blended data - I took the data to Qgis and created regions in a layered point spatial map and brought that into Tableau
you can plot the "Points" against a filled map and still fill the map
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Yeah, I think that goes back to the problem I'm having with how basic my data is, the only geographic info is 4 different regions.
I tried to go a different route and join my key directly to my primary data source (using the lower left data source editor). The problem there is that being a one-to-many join (each record has just one region in the primary data source, but each record in the key has several rows of states) so my numbers are now off (they're being multiplied by however many states make up each region). Trying to think of any way around that issue.
if that is the case you could make a simple region/state cross match file (its only 50 records) and join it to the state level file - it will work like a Vlookup in excel and add a Region field to each record at the row level
I think that's what I already tried, if I'm following you correctly. Below are some example tables to represent what I did.
On the left is my example data, on the right is the state to region key I made (for all 50 states).
The issue I'm running into with the join is that instead of the aggregate data saying I have 25 jeans units in the midwest, it's creating a distinct row for every state and is aggregating to say I have 100 jeans units in the midwest.