I want to just look at 1 hour for yesterday, but I want it to be relative to today so no matter when I look at it in the future it will always be yesterday.
So if I look at it today it will show yesterdays value at 12pm to 1pm
And if I look at it next week it will show the day before that day at 12pm to 1pm
I am thinking of something like -1d@d
for the earliest and @d
for the latest but how do i get the hour I want?
-1d@h
to -23h@h
You can use any of the units for range as as your "snap to" boundaries.
-1d@h
to -23h@h
You can use any of the units for range as as your "snap to" boundaries.
will that work? will that not always be 23hours ago from your current hour. I want same hour for yesterday all the time.
I just had another thought, it could also be specified as @d-12h to @d-11h.
So what you are saying is that you will always want the hour 12:00..13:00 of the previous day.
OK, so that should be -d@d+12h
to -d@d+13h
.
You can add and subtract offsets after the snap.