I developed a quick little R utility that converts a Sense daily output file for a year (or even multiple files for multiple years) into a weekly usage history by kWh and by percentage of total usage. I’m willing to run your data through as well if anyone is interested. One example, I did for another user yesterday, below - you can tell the cooling season is “heating up” in Texas (77316 zip)
PM me if interested. All I need is a yearly Sense export CSV at the daily level.