grafanainfluxdbgeomap

my "lon" coordinate doesn't show up in a Geomap of Grafana


I have a problem with the geomap visualisation in grafana. My data is stored in influxdb, It is stored as seen in this screenshot : data query (lon and lat are float)

My problem is when I try to display it as geomap in Grafana : It only works if I fill lat and lon with the field "latitude", as if "longitude" was not recognised... With lat and lat, it works (but it's not the good location! but With lat and lon, problem

yet both fields are float... I use Grafana v10.4.2 (22809dea50)

I tried to modify each configuration field to see if there is a bug somewhere. I tried the "auto" mode to get coordinates, the manual mode, modify the aliases... I also did a "math(/100)" to be very sure that "lon" is recognised as a float, and it's ok for this !

I except the "lon" to be recognised !


Solution

  • I managed to find a solution.

    In my opinon it is a bug of Grafana, that doesn’t take in account multiple “timeseries” fields in the request. It takes only the first field.

    Here is the solution : in the request, format data as Table, not as timeseries…

    Screenshot of the format option