Multiple Thresholds in a single panel

[fadilck01]

• What Grafana version and what operating system are you using?

• Grafana 11.2

• What are you trying to achieve?

• Adding multiple thresholds for one metric in a geomap dashboard panel

Hi,

I have created a GeoMap panel with longitude and lattitude of few locations acroos the globe. I added switch latency of the respective locatiion in the panel. I gathered data from different datasorce and created couple of transformations to create a table like below

Location Latitude Longitude Latency
London -0.12 51.5 1.5ms

I have latency from multiple, locations. The latency threshold is different for different locations. Is there an option in Grafana to set different thresholds to different locations? So that the map locations changes it’s color based on the locations.

Regards
Fadil

[infofcc3]

Hello @fadilck01 please confirm this is your requirement …

[fadilck01]

Hi,
Currently I have route between each locations. It would be better if the route line colors are changed based on thresholds. If that’s not possible. Then it would be helpful if it changes the location color as shown in image which you have attached.

[yosiasz]

Part One
in geomap you can do it using a dynamic numeric value for Color coming from your data

and selecting a color scheme in Standard Options

But you have 0 control over what size and color.

Part Deux
Another approach would be to use Business text with leaflet

Leaflet.js | Volkov Labs

[infofcc3]

Fetch data using this query…

SELECT 
    l.location,
    l.latitude,
    l.longitude,
    l.latency_ms,
    t.threshold_ms,
    CASE 
        WHEN l.latency_ms > t.threshold_ms THEN 'High'
        ELSE 'Normal'
    END AS status
FROM 
    location_latency l
JOIN 
    location_threshold t ON l.location = t.location;