[Bug] [User Experience] Map does not show variance when looking at longer durations

[paulb-elastic]

When viewing the User Experience app for a shorter time range (e.g. 15 minutes), the map shows a gradient of colours, based on the average duration page load for that region, such as:

However, when a larger duration is chosen (e.g. Last 7 days), the map doesn’t show any gradient colours, for example:

Note as shown above, the mouse overs are still showing average page load duration, so there is still data associated with the map.

Possible related points of reference: #78788

[elasticmachine]

Pinging @elastic/uptime (Team:uptime)

[nreese]

@shahzad31 and I looked into this and its caused by outliers in the data set. The styling used by the APM map is a linear gradient. So an outlier on the high end will result in everything getting styled with the first gradient level.

We discussed solutions and one was to use percentile aggregations to define the range bands.

As a work around, APM could generate the percentile bands and pass in a customized color ramp that uses the percentile bands for styling.

[elasticmachine]

Pinging @elastic/kibana-gis (Team:Geo)

[shahzad31]

i had tested this after you closed the issue @nreese adding a where query will resolve this, as demonstrated in my draft PR #81106