Create histogram showing yesterday value

Hi,
I’m creating an histogram showing yesterday value but I don’t know how to set the fixed timeframe.
This is my query:
SELECT
__timeGroupAlias(timestamp, 1d), description as metric, sum(value) AS value FROM `table` WHERE __timeFilter(timestamp)
GROUP BY 1,2
ORDER BY 3 DESC

How can I change the where clause to override the selected time in the panel and showing the data of yesterday ?

I added to my query the column $__timeGroupAlias(timestamp, 1d) otherwise I couldn’t display correctly the graph but I don’t think it’s a good choice because on the graph now appears “Data outside time range”. Is there another solution to display correctly the data without this warning ?

Thanls a lot