Yesterday Time Range - how to graph just yesterdays data


I have been trying to use override and timeshift to show results for yesterday in a time series graph that just displays yesterdays measurements for the 24 hours.

I have tried all sorts of combinations but just can’t seem to get there. Maybe its not possible or hopefully somebody smarter than me can help. The attached pic shows the closest I can get and the settings but it is the 27 April today and it displays 25 April and part of 26 April up to the time right now. I just want to show 24 hours of 26 April.

OK I think I got it. I don’t know why but this seems to work.