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