This is my Configure ；like query A
SELECT sum(“value”) FROM “status” WHERE “domain” = ‘$Domain’ AND region =~ /^Region/ AND host =~ /^host/ AND $timeFilter GROUP BY time(1m) fill(null)
my question is，how to Configure yesterday’s data; maybe it is query B
1 Like
Look at the “Time Range” tab.
Leave the query just as it is and modify the “timeShift” parameter to “1/d”.
If you want the day before yesterday, make it “2/d” etc.
https://localhost:3000/t/difference-between-two-singlestat-values/16789
is also relevant.
Antony.