Hello, Is there any way i can get the time range we selected on the dashboard into a variable, so that i can use the same in my query. I wanted to have a single stat for TPS for the time i selected on the dashboard . I have the total number of requests from influx db. How can i get the time select…

As yosiasz properly pointed out, you can use “ Global variables ”. MS SQL code: SELECT [DateTime] ,[AirTemp] FROM [meteoData] WHERE [DateTime] BETWEEN '${__from:date:iso}' AND '${__to:date:iso}' ORDER BY [DateTime] DESC;

Anyone know if it’s possible now?

Would built in variable $__range do the trick for you?

It’s my understanding that $__range is only supported for a Prometheus data source, and mine is MySQL, so I think not, but if you know a way to use it with MySQL that would be awesome

Grafana Docs suggest to use $__timeFilter for MySQL: https://grafana.com/docs/grafana/latest/variables/variable-types/global-variables/#timefilter-or-__timefilter

What I’m looking to do is a simple SELECT to just display the amount of time in the select time range. For some reason when I use $__timeFilter I get the ERROR :Unknown column '$__timeFilter' in ‘field list’.

Hey! Did you find the answer? I’m looking for this as well.

[image] Global variables Global variables Grafana has global built-in variables that can be used in expressions in the query editor. This topic lists them in alphabetical order and defines them. These variables are useful in queries, dashboard links, panel links, and data... …

How to get the time range selected on the dashboard into a variable

Grafana Stat Panel

yosiasz August 1, 2022, 12:22pm 10

1 Like

Topic		Replies	Views
Updating stat value depending on time range giving in grafana dashboard Grafana	2	2779	February 8, 2022
How can we link Grafana time filter with our SQL query? Dashboards	4	628	December 1, 2024
Is Possible to get value from time range grafana and put it inside query in table panel? Grafana	0	577	January 2, 2019
How to use dashboard time range in panel query? MySQL mysql , query-help	4	19021	June 19, 2024
Add the time range variable to (postgresql) query (in the panel) Dashboards time-selection , timestamp , dashboard , dashboard-variables	2	9107	March 13, 2023

How to get the time range selected on the dashboard into a variable

Related topics