Timepicker is not working well to my table

Grafana Dashboards
1

  • 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?

2

welcome to the :grafana: community @jaeseolee!

To get your query to use the dashboard time range, you’ll want to use the $__timeFilter macro. The full example is available here in the plugin docs

SELECT
    silo, microservice_name, instance_name,
    CREATE_TIME_SERIES(time, measure_value::double) AS gc_pause
FROM $__database.$__table
WHERE $__timeFilter
    AND measure_name = '$__measure'