I am new to creating Grafana dashboard. I have a table in the dashboard with a SQL Query.
I want to use the time selector at the top right in Grafana in the SQL query so that only data in that time is shown. Could someone please help with this.
My Query is structured as followed:
SELECT char_value , time_stamp
WHERE tag = ‘tagname’
AND time_stamp > subtractSeconds(now(), 300)
ORDER BY time_stamp DESC
I want to change the selected sentence in query to filter time as per time range selector.
I have tried $timeFIlter but it looks like that doesn’t work for tables. Please let me know if you have a solution