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