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?
Could you potentially change it from a Bar Graph to a Pivot Table, then in Row have both "Primary Address Post Code" and "Primary Postcode Short?"
Couldn't you use the LEFT function to ensure all data in that field is normalized to five digits? Something like LEFT([Primary Address Code Short], 5) might get you what you want. Just riffing, here but if you can switch to a pivot table and get the data normalized in there using the LEFT function, you can probably switch back to the chart you were using once the data is normalized.
LEFT([Primary Address Code Short], 5) might get you what you want. Just riffing, here but if you can switch to a pivot table and get the data normalized in there using the LEFT function, you can probably switch back to the chart you were using once the data is normalized.
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