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?
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
You can add and subtract offsets after the snap.