I have over 12 months of electricity usage in my HA - I can browse all that data in the Energy Dashboard which is great.
But for one of my project I need average electricity usage on a Saturday for the past 4 weeks, I was thinking about using the SQL integration but I have no idea how to construct the sql query.
Any suggestions will be greatly appreciated.
Thanks