Get Yesterday Latest Value

I use this query to display latest value of a timeseries in a gauge:

SELECT last(value) FROM "Wh" WHERE ("friendly_name"::tag = 'Consumo - Giorno - Caldaia') AND $timeFilter

I need another gauge that show me latest value of yesterday. How can I achieve this?


Welcome @marcolino7

Maybe do a union

Select previous… union
Select yesterday

Type of thing

1 Like