Hello everyone!
We have a dashboard that shows us top 10 postal codes by ticket count. We always get a huge (none) category. We recently discovered that (none) was 9-digit zip codes. Is there a work around for the (none) zip codes to show up without changing the category?
We switched the dashboard from "Primary address postcode short" to "Primary address postcode." This got rid of the (none) category, but now our data is split up in a way that is not helpful for us. Is there a way to group the postal codes by the first 5 digits?
I would be curious as to why your category of "Postal Address Postcode Short" is giving you 9 digit values. I am still not über-fluent in all things Analytics, but that to me would seem like the very definition of the value it is supposed to be providing. Is there something odd with your data causing it to react that way?
I just looked at one of my dashboards where I am using that exact value to return zip code data and it is working just fine. I just looked a performance where we have a number of tickets in a specific zip code, and I confirmed in the database that, while most of those are all 5 digit zip codes, a solid 15% or so have the full 9 digit zip codes saved to the address in our database. But the numbers match exactly as to imply it only pulling on the first 5 digits. And I am definitely not doing anything particularly special in this dashboard. I am pretty sure this was just an ever-so-slightly modified version of a default/standard Tessitura dashboard in fact.
Might be worth asking Tessitura about this one. Best of luck!
John A. Moskal II