How to pull two measurements in Grafana from Amazon timestream

Grafana
1

I am trying to vizualize my GPS points on the TrackMap panel using Amazon timestream as my data source. I have two measurements (latitude and longitude), but I am having difficulties to get a reading on the trackmap panel. From $_measure on the marcos settings on the panel, only one measurement can be included. This is my query?

SELECT DevEui, CREATE_TIME_SERIES(time, measure_value::double) as “latitude”
FROM “my_LoRaWANDatabase”.“my_LoRaWANTelemetryTable”
WHERE measure_name = ‘latitude’ and DecoderName=‘None’
GROUP BY DevEui

How can I include the longitude?
Please anyone to assist?

2

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