Timepicker is not working well to my table

  • What Grafana version and what operating system are you using? Cloud

  • What are you trying to achieve? Trying to show data from AWS Timestream

  • How are you trying to achieve it? Grafana + AWS Timestream

I use this query

SELECT
device_id,
SUM(case when measure_name = ‘ntu’ then measure_value::double end) as ntu,
SUM(case when measure_name = ‘shutterspeed’ then measure_value::bigint end) as shutterspeed,
SUM(case when measure_name = ‘intensity’ then measure_value::double end) as intensity,
time
FROM $__database.$__table
group by device_id, time
order by time DESC

  • What happened? I made a table. Howerver I cannot apply time range from Grafana

  • What did you expect to happen? I would like to get data by using time range

  • Can you copy/paste the configuration(s) that you are having problems with?

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

  • Did you follow any online instructions? If so, what is the URL?