How to use the selected period of time in a query?

Question

I'm using Grafana with Prometheus and I'd like to build a query that depends on the selected period of time selected in the upper right corner of the screen.

Is there any variable (or something like that) to use in the query field?

In other words, If I select 24hs I'd like to use that data in the query.

Frederic

Answer 1

There are two ways that I know:

1. You can use the $__interval variable like this:

    increase(http_requests_total[$__interval])
   

There is a drawback that the $__interval variable's value is adjusted by resolution of the graph, but this may also be helpful in some situations.

2. This approach should fit your case better:

Go to Dashboard's Templating settings, create new variable with the type of Interval. Enable "Auto Option", adjust "Step count" to be equal 1. Then ensure that the "auto" is selected in corresponding drop-down list at the top of the dashboard.

Let's assume you name it timeRange, then the query will look like this:

increase(http_requests_total[$timeRange])

This variable will not be adjusted by graph resolution and if you select "Last 10 hours" its value will be 10h.

Chretien

the 1st option does not work when querying in the Grafana tile (I wanted to create a pie chart). the 2nd option shows me 1s for 1m, 1h, 1d chosen time ranges. How to see the values in right values? – Strawn

Answer 2

If you are looking at using prometheus as data source, $__range supports your dashboard time is great.

 increase(gin_total_requests[$__range])

Why create your variable when you can use inbuilt Global variable.

I have added links to documentations to back up my answer Grafana 5.3+

Piety

This is the answer to the question and should be on top, even if the answer actually on top works and provides an interesting approach. – Pasticcio

Do you know why I am not working increase when I do a 24h range through the picker time range? The data exists because if I remove increase and $__range , it shows me data. – Graner

This answer must be in top. – Tribal

Answer 3

count_over_time({job="gerrit-sshd"}[$__interval])

It works for me and what's more, you should set Max data point as 1 ,in query option.

Then the $__interval is the same Time-Range from the Panel on Grafana top right corner.

Trustbuster