Hi Analytic Users,
I am looking to pull a list of zip codes for several seasons. The challenge we are running into is Analytics does not recognize the same 5 or 9 digit zip codes as the same postal code. I understand they are technically different numbers, but for our purposes it would be great to merge them all together. Does anyone have a work around other than exporting the data and then compiling the zip codes manually (or through functions, etc.). Here is a reference: https://www.screencast.com/t/eeRWBaA3aICC. I am hoping there is a quick function or a setting I may be missing in analytics. Thanks,Joe
In the Constituent Dimension,
Field: Primary Address Postcode Short
Definition: The trimmed version of the postal code of the primary address for the constituent.
Notes: Default is to include the 5 leftmost characters, and may be configured per division by an administrator.
Page 449 of Tessitura Analytics.
Does this help, I just happened to stumble upon it today?
This solves it Neil. Thank you for sharing your stumble!