I have imported a single csv file Postal Codes (PC) and Forward Sortation Areas (FSA) -- FSA is the first three characters of the PC.
Once imported, I can plot the PCs fine, but the FSAs give 126 null >> edit location >> "ambiguous" ... This is because there is more than one FSA per PC.
I tried the solution posted here (How to make locations permanently unambiguous (Preferably without adding other fields to the view)) -- adding a max(PC) to the shelf, but *** did nothing.
Solved it ... had to add second custom geocoded file with only the FSA ... but is there a benefit to adding both PC and FSA in one of the files?
Attached workbook as a reference.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...