Apply filtering template in hindsight

Configuration
1

Hello,

I want to design a custom sensor (in my case a dew point sensor for a room and humidity control). Now, I can try this out using a template sensor and the physical information from whatever source. However, I would like to test it out before actually creating this sensor.

Also, it would be nice, if this information could be calculated in hindsight (assuming all inputs are in history available).

Is it possible to define some sort of custom filtering that is not restricted to the current time (plus the future) for which I have to wait until a significant amount of data has accumulated to see if the values do make sense? I would need a way to define a template and tell HA to evaluate for all past times (with long-term history ideally) to evaluate the template and plot it in some way.

Thanks
Christian

2

I don’t think you can create sensors in Home Assistant that work with historical data directly (if someone knows better, then please correct me).
But what you can do, is exporting the historical sensor data to a csv file, and import these in for instance Excel. Than you can use the same filtering (formula) as you want to use in Home Assistant to simulate your intended dew point sensor.
First show the historical data that you want to use in the History pane, and then export the data to csv via the three dots in the upper right corner: “Download data”.