Show sensor value from 24 hours previous

[radeon]

Well after a good bit of hunting round, this got me what I was after:

Get temperature from yesterday

After a lot of trial and error I taped this SQL query together: # Get the sensor value at a specified time - platform: sql queries: - name: Temp. piscina ontem query: "SELECT * FROM states WHERE entity_id = 'sensor.temperatura_piscina' ORDER BY ABS(strftime('%s', created) - strftime('%s', '2019-11-07 12:00:00', 'utc')) LIMIT 1;" column: 'state' Although the time (hour) seems shifted in the state window, it seems that it’s getting the right value. Timezones can be a …

- platform: sql
  queries:
    - name: Pool Temperature Yesterday
      unit_of_measurement: "°C"
      query: "SELECT * FROM states WHERE entity_id = 'sensor.pool_temperature' ORDER BY ABS(strftime('%s', created) - strftime('%s', datetime('now'), '-1 day')) LIMIT 1;"
      column: 'state'