Hello, I have a data for 3 month of energy consuption which is compounding and always increases. I dont have data for current consuption. If I will extract data into excel I am able to calculate consuption between dates, times etc and reproduct hourly, daily and monthly exact usage but on Excel. I need to do this on Home assistant, I have tried statistics function which was not able to figour out. Please advise how can I create simple statistics data for my existing and currently compounding data.
Regards,
Turkel.