Last data for 2 fields in InfluxDB query

  • What Grafana version and what operating system are you using?
    Grafana 8.0.3, Ubuntu 20.04 LTS

  • What are you trying to achieve?
    Show the last location on WorldMap plugin

  • How are you trying to achieve it?
    Latitute and Logintude are stored in InfluxDB. When I use the following query:
    SELECT LAST(“latitude”), “longitude” FROM “Test” WHERE (“location” = ‘GPS’)
    I do get the last value.

> SELECT LAST(“latitude”), “longitude” FROM “351561110228836” WHERE (“location” = ‘GPS’)
name: 351561110228836
time last longitude
---- ---- ---------
1624788070243314898 XXXXXXX YYYYYYYY

  • What happened?
    But when I use the same query in the Grafana dashboard, I am getting error

  • What did you expect to happen?
    The Influx query that was working on command line show work in Grafana as well.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.