Orchestra Cities dont plot data on maps

[Rev]

Hello everyone,

I am using Grafana 10.2.3 Orchestra Cities Map and it drives me crazy. Because i dont get the position shown on the map.

this is my insert
data = "loco,uic=111111111ups_load_voltage="+str(load_voltage)+",ups_current="+str(current)+",ups_power="+str(power)+",ups_percent="+str(percent)+",ups_hs="+str(hs)

and the data of the insert look like that
car,uic=11111111 gps_hdop=0.8,gps_height=458.1,gps_latitude=40.4665013,gps_longitude=13.513669566666668,gps_quality=1i,gps_satellites=6i,gps_speed=0

so this all works for me.

my request in grafana looks like this

from(bucket: "bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "loco")
  |> filter(fn: (r) => r["uic"] == "11111111 ")
  |> filter(fn: (r) => r["_field"] == "gps_latitude" or r["_field"] == "gps_longitude" or r["_field"] == "gps_speed")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

And again everything is fine i am getting the data like i wrote upstairs

So this is the config i did in the plugin everything fine as well i think

The only thing what I cant explain and what makes me suspicious is that i can choose 3 times the

So on this problem now for 3 days. Any ideas?

[rafaelhiguera]

Same issue here. I think, after hours searching, that the data that I get from the API, changes and add a new json which contains “refId:undefined”

field which I suppose that is needed for selecting the correct series in “query” field which is filled with 2 fields but with no name (is very difficult to see but the drop-down control contains 2 null items if you have 2 series), so despite I have 2 queries available in datatable view, I don’t have this option in “query” field, so, finally the first query is used by all the layers

[yosiasz]

you need to pivot the data.

something like this but change according to your data

  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")  
  |> drop(columns: ["_start", "_stop", "_measurement", "type"])

google