Grafana-InfluxDB-Geomap

Hello all,

I think i have some diffuculty in create quaries with influxdb when using Geomap. I have examined all the topic on this task, but i have not been successful. I will try to show the problem i have experienced in detail. I hope this topic will be useful for others

my structure likes ; opcua(simulator) → telegraf → influxdb → grafana

query on influxdb(only for example grafana query is difference) ;

I’m using geohash(string) for location mode

Grafana side ;

i have 2 query for different locations, and each location has 1 specific data

query 1 :
specific data is ST

query 2:

specific date is Temperature

if I do not add join by field transform data it does not work properly;

and if I add this transform data, I cannot select different data queries in different layers (such as query:A,query:B). I added transform data combines my queries ;

and as a result, when I go over location 1, it shows all the data in the query, although I only want to see the specific value belonging to it.

What I want to do is ;

if I go to location 1, only the “ST” value
If I go to location 2, I only want to see the “Temperature” value.