[SOLVED] "This week" timerange strange behavior ($__range) with slow counter

Grafana Stat Panel
1

Hello everyone here,

I use Grafana version 5.3.2 with a prometheus data source

My request is the following:

Blockquote
sum (
+ max_over_time (my_counter_total[$__range])
- min_over_time (my_counter_total[$__range])
)

“my_counter_total” is a slow counter ~ 200 increase per week.

When I use the time range filter “This week so far”, it works fine and shows the right value, ~100, when I run the request on Wednesdays.
When I use the time the time range filter “This week”, the value is not correct, ~60 to ~80, when I run the request on Wednesdays.

To narrow down the problem, I use the time selector from Monday 00:00:00 to Sunday 23:59:59, and it results in the same wrong result.
Then I use the time selector Monday 00:00:00 to Next_Monday 00:00:00, and the result is then correct.

The other time filter work perfectly.

Anyone here have seen this issue, or could help me to understand it? Any help would be very appreciated.
Thanks
Gael

2

I found out that this problem comes from the ‘__range’ variable which is “too rounded”.

Using ‘__range_s’ instead solved my problem.

Blockquote
sum (
+ max_over_time (my_counter_total[${__range_s}s])
- min_over_time (my_counter_total[${__range_s}s])
)