i have influx db series which has record in the following format:
the 2nd value is a string of latitude,longitude coordinates and i want to display the locations trackmap panel but not sure how to configure it.
the query in influx to retrieve these records (from influx cli) is
SELECT “state” FROM “state” WHERE (“entity_id” = ‘lsx_location’ AND “domain” = ‘sensor’)
in grafana i’ve tried this:
the problem is that the lat/long are a single value separated by a comma.
is it possible to separate the [lat],[long] values to 2 and use it as as input for trackmap?