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”
WHERE measure_name = ‘latitude’ and DecoderName=‘None’
GROUP BY DevEui
How can I include the longitude?
Please anyone to assist?