Grafana variable - Interval mutiplier

Question

I am drawing a graph in grafana where I am getting the rate of one counter and subtracting it from rate of another counter. I am using the Interval Variable in the graph. Now when I want to use 5m as interval, I want the rate to be multiplied (5*60). Similarly when 1h then it should be multiplied by (1 * 24 * 60 * 60)

$period = 1m,5m,10m,1h and like this.

My query

rate(service_total{state="otp_send"}[$period]) * 300 - ignoring(state) rate(service_total{state="otp_validate"}[$period]) *300

So I want this 300 to be put in a variable which changes when I change the $period value in grafana

> If $period is 5m, 300 should be 300 
> If $period is 1m, 300 should be 60
> If $period is 10m, 300 should be 600

And in this way. Is there something that I can do in grafana.

SO basically I want to attach the $period to a constant variable that multiplies according to the interval.

score 2 · Accepted Answer · answered Jun 10 '20 at 18:12

2

  increase(service_total{state="otp_send"}[$period]) 
- ignoring(state) 
  increase(service_total{state="otp_validate"}[$period])

increase is syntactic sugar on top of rate that does this.

answered Jun 10 '20 at 18:12

brian-brazil

31,678
6
93
86

Marcelo Ávila de Oliveira · Answer 2 · 2020-06-11T12:13:02.340

1

You can change from "rate(vector)*time" to "delta(vector)" to get the same result, like the following:

delta(service_total{state="otp_send"}[$period]) - ignoring(state) delta(service_total{state="otp_validate"}[$period])

More info in the Prometheus documentation here.

UPDATE:

As @brian-brazil replied, the correct in this case is to use the "increase" function instead of the "delta" function because the second one doesn't deal with counter resets.

More info in the Prometheus documentation here

edited Jun 11 '20 at 12:13

answered Jun 10 '20 at 12:28

Marcelo Ávila de Oliveira

19,950
3
39
50

It is incorrect to use `delta` with counters, and in general it is not a function to use as you usually want either `deriv` or `increase` instead. – brian-brazil Jun 10 '20 at 18:11
I can't see the difference between "delta" and "increase" when used with counters. Can you explain the difference? – Marcelo Ávila de Oliveira Jun 10 '20 at 18:49
Delta doesn't deal with counter resets, as it's intended for gauges. – brian-brazil Jun 10 '20 at 22:03
Ok, thanks. Do you think is it better to remove the answer to not confuse people? – Marcelo Ávila de Oliveira Jun 10 '20 at 22:28
That's up to you, maybe an edit to indicate why it's incorrect? It's not an uncommon mistake. – brian-brazil Jun 11 '20 at 08:05
1

I think this answer is more useful because a) it links to documentation and b) it explains why it is wrong :) – user10489 Jul 30 '23 at 02:48

Grafana variable - Interval mutiplier

2 Answers2