Fixed Time-Interval for one Graph

Grafana
1

Hello,

For one complete graph, I would like to fix the range to a different range (fixed to the last 7 days) than the one that I select interactively.
What I try:

SELECT mean("value") FROM "Series" WHERE time > now() - 7d GROUP BY time($__interval) fill(none)

But still, my x-Axis is changed by the Range that I select interactively (and that is usually 1 day only).
I would have to fix the x-Axis.
Furthermore, I do not know what to select for $__interval.

Is my Plan possible?

Greetings,
Hendrik

2

Hello,

is that not possible, or have I just phrased myself really badly so that noone understands me :wink: ?

Greetings,
Hendrik