Using lat/long string entries from influx to populate trackmap coordinates

i have influx db series which has record in the following format:
1600371536613116928 32.19145605569006,34.874109619475526
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?

Hi @impeham I’m having the same need, where you able to solve it?
KR