Hello folks, Please help me figure out how to customize the legend values of my choropleth map. I'd like to get the average logon duration of each device and then have a choropleth map (which is working based on country) and set legend green if avg_logon_duration was equal or lower than 10; yellow if it was between 11 and 20 and red if greater or equal to 21. Here is my current table structure: country device logon_duration Brazil XYZ01 21.05 USA ABC01 16.99 Germany FE-01 5.75 India MUM01 10.00 I've already tried to use rangemap and also editing XML with mapping.fieldColors ({"green":0xFF0000,"yellow":0xFFFF00,"red":0x00FF00}) which I found in another article, but it did not work. Here is my last code: | stats avg(logon_duration) as avg_logon_duration by CountryName
| geom geo_countries featureIdField=CountryName
| rangemap field=avg_logon_duration green=0-10 yellow=11-20 red=21-99 default=white The closest I got so far was using mapping.seriesColors with colors array [0xFF0000,0xFFFF00,0x00FF00], but it completely ignores the categorical values I choose on the choropleth map. Any help would be really appreciated.
... View more