Bug? 900 item Limit to Postal Codes in Filled Maps

Looker Q&A Looker Studio
, ,
1

Heyo!

I created a heat map for a client in Looker Studio to show where customers from each of their two nail salon locations live. The data comes from a Google Sheet, with each row representing a client’s home zip code and the salon location they visit. One location has 800 clients, while the other has 1,900.

When I filter for the location with 800 clients, the zip codes display perfectly. However, when I filter for the location with 1,900 clients, the borders of the zip codes distort and render inaccurately.

I ran a test with a smaller data set and discovered that once I include more than around 900 zip codes, the map starts to malfunction.

Is this a known limitation? Does anyone know of any workarounds?

Thanks!

Bad (over 900 Postal Codes)
Bad (over 900 Postal Codes)784×782 123 KB

Good (under 900 Postal Codes)
Good (under 900 Postal Codes)798×782 111 KB

2

Hi @JMZA , thanks for your post!

Per the Looker Studio Google Maps chart reference page, these are the max data limits:Maximum data limit:

  • 1 million bubbles for Latitude, Longitude fields.

  • 1 million points (polygon vertices) for Geospatial fields (BigQuery GEOGRAPHY).

  • 3,500 bubbles or filled areas for other geographic field types.

    Increasing a map’s data limit can make it load more slowly.

I think you may be hitting a bug - would you be able to file a report with the information you’ve gathered and submit it following the instructions here: https://support.google.com/looker-studio/answer/13606940 ? This will help our team get started investigating what could be going on.