For each graph panel, I want to set a custom start date (for example : 26/01/2020 ) and a custom end date (for example : 26/03/2020 ). Basically, an absolute time range .
I know that on each panel you can set a relative time range but you can’t do something like that using relative time.
Hey there, if you are still searching then here is what worked for me.
Use the below query and set the time range to today from time picker. Then, you can adjust the time shift factor in the below query according to what you need.
SELECT count(“value”) FROM “measurement” WHERE time > {__to}ms-7d AND time < {__to}ms GROUP BY time($__interval) fill(null)
Hello,
I am trying to do the same thing.
Or any option that automatically adjust start and stop of the panel to the timestamps of the first an last retreived data ?