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.

This topic was automatically closed after 365 days. New replies are no longer allowed.