How can we link Grafana time filter with our SQL query?

Grafana Dashboards
1

We have created a dashboard using SQL queries in Grafana. We want to link Grafana in-built time filter with our dashboard so that we can filter data as required. Kindly guide how can we map it? Thank you.

image
image327×112 2.12 KB

2
3

Thanks. Can you also guide how to create global variable for this? And how to map it with our dashboard/Query?

4

they are built in, and you can call them from your query

5

For PostgreSQL, the syntax to include template variables looks like this:
SELECT * FROM "ElectricPowerOperations" WHERE "type" IN ('Demand') AND "region" IN (${region}) AND $__timeRange(time)

More examples here.