5000 row limit blocks heatmaps from showing all markers

[Jjimi]

Hello, 

The row limit feature on Looker is causing issues with loading all data on heatmaps.

I was wondering, therefore, if there is a way to increase or remove the limit.

Here are the details.

Issue: 

The row limit of 5000 is preventing all markers from being displayed on the heatmap.

Description: 

We use in-game coordinates from data sent by the players every second to display locations on the game map.

It triggers the data frequently, causing the result to exceed the 5000 row limit.

Actual result: 

When the number of rows is limited, the markers on the map are displayed abnormally.

Sometimes no markers are shown, or sometimes half of them are shown in the wrong location when running the query.

Expected result: 

All markers should be shown on the map in the correct location.

Alternative: 

We have tried rounding up the coordinates using {% parameter scale %}.

I have created a separate Look as an indicator when the total row exceeds 5000, depending on the result of filtering.

So, I have built at least three objects whenever I have made heatmaps: heatmaps, the indicator, and the scale filter.

However, rounding up the coordinates has not always been the best solution.

So, I was wondering if there is any way to raise the bar or remove it for heatmaps specifically.

Thank you.