-
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
Hello @fadilck01 please confirm this is your requirement …
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.
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
1 Like
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;