Time Picker not working for: geomap, table

Grafana Dashboards
1

Hi,

I have a dashboard with a couple of geomaps and a table. I want the time picked from the time picker to also change what you view in my geomaps and my table.

I found some variable that could help, but I get an error if I use this method.

SELECT 
  CAST("Longitude" AS DOUBLE) AS lon, 
  CAST("Latitude" AS DOUBLE) AS lat, 
  CAST("Direction" AS INT) AS direction, 
  CAST("Speed" AS INT) AS speed
FROM ${database}.${table}
WHERE "Filter" = 'mon' AND $__timeFilter(time)
ORDER BY time DESC
LIMIT 10

I am using AWS Timestream datasource in Grafana.

ValidationException: The query syntax is invalid at line 7:110

Somebody know a solution?

2

got it, simple solution:

SELECT 
  CAST("Speed" AS INT) AS speed,
  CAST("Longitude" AS DOUBLE) AS lon, 
  CAST("Latitude" AS DOUBLE) AS lat, 
  CAST("Direction" AS INT) AS direction
FROM ${database}.${table}
WHERE 
  "Filter" = 'mon' AND $__timeFilter
ORDER BY time DESC
LIMIT 10
1 Like