Sensor Value from yesterday, day before, at the same time as now

Is there a way to show e.g. the value of my daily-kWh sensor as it was yesterday at the same time as now, or the day before at the same time as now?
Or what my daily water usage was from the flume sensor yesterday at this time?
I know that the values are all in the MariaDB, but I don’t know how to define a sensor that would display a value from a specific time in the past :confused:

Have you found/considered the below?

Didn’t see that before but I’ll definitely look through that thread - thanks @Chandler