I just set up the Energy-Dashboard. Very nice so far.
My problem came up when i wanted to see some statistics from a few month ago.
The sensor values are removed from the HA SQLite after a month.
Since all this values are also stored inside Influx, is it possible to access the InfluxDB for some Entities instead of the SQLite?
The energy dashboard doesn’t use values from the states tables, which as you noted are removed after however long your recorder purge settings are set to. Instead, the energy dashboard uses the long term statistics from the statistics table which are retained indefinitely.
If your sensors aren’t creating statistics, you need to make sure they are set up correctly: