ive got the data importing and added it as a sensor but when adding it as a solor reading it reads the correct value, but the energy dash says 0kwh. Even though it reports 5kwh.
will this work?
Perhaps you missed to declare the entity not being a number, if ever decorated by a unit_of_measurent (visual thing) while still being treated as a number not as an energy value?