Hi, I am on version 8.1.1
I created a dashboard variable as described here TimeFilter in panel name, values on graphs
I am using the following variable: $__interval
But it does not brings the right values(not always)
For instance when the interval 2days it returns 2
But when the interval is 45days (now-45d) the variable $__interval returns 30
Please advice
1 Like
Hi @gurvichvitaly
Have you read our documentation about the $__interval
global variable? Here is a snippet about how it works and some other notes about using it with influx:
The $__interval
is calculated using the time range and the width of the graph (the number of pixels).
Approximate Calculation: (to - from) / resolution
For example, when the time range is 1 hour and the graph is full screen, then the interval might be calculated to 2m
- points are grouped in 2 minute intervals. If the time range is 6 months and the graph is full screen, then the interval might be 1d
(1 day) - points are grouped by day.
In the InfluxDB data source, the legacy variable $interval
is the same variable. $__interval
should be used instead.
The InfluxDB and Elasticsearch data sources have Group by time interval
fields that are used to hard code the interval or to set the minimum limit for the $__interval
variable (by using the >
syntax → >10m
).
1 Like
Excellent. I found what I looked for.
Actually it should be something like Round((($__to) - ($__from) ) / (1000 * 60 * 60 * 24), 1) to get the dashboard selected time range in days.
Tnx.
2 Likes