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?
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.