Just chiming in to make a note that I have hit this issue with the statistics integration and trying to use a change of humidity in the past 5 minutes as a trigger.
What happens is that the humidity sensor is very stable, and the value is not changing. Then someone takes a shower. The humidity spikes up hard, and I’d really need to capture that original bottom level humidity from which the situation got triggered.
But I don’t, because “it works as specified”. The database doesn’t seem to store the polled humidity values when the value remains the same, and when the statistics integration is working on its 5-minute change calculations, it has no value from the bottom of the humidity graph, even though if I look at the humidity graph in Home Assistant I can see that it draws it mostly correctly in a fashion where the line drawn continues along the not-stored values until the spike up.
But the statistics integration works with the database, not the graph, and when it looks for values in the past 5 minutes, all those times the humidity polled the same old value, went to bit heaven in an acute case of it works as specified.
Now I suppose I could fix all the integrations in home assistant, of course. Or I could fix the core, database, whatever. But alas, I don’t know all the integrations, and there are too many, and I don’t know the core either. So I’m left with the vote button.
I sincerely hope others will take the time, register, and vote. Maybe someday, someone picks this up. Us users, we don’t want to change your beautiful design, it can be as it is, but we want something new - without specifying the “how” in details - that works even a bit better than the initial, beautiful design.