How do I use an SQL sensor to retrieve a past attribute value?”

Configuration
1

It was suggested that I start this new thread.

Essentially I’m looking for getting the SQL sensor to give me not only past state of entity, but also attributes. I simply want to get a light state, brightness and colour from 7 days ago.

Any help would be appreciated.

1 Like
2

as @tom_l suggested, let’s use a real world entity:

light.parents_bathroom_main_light