Energy consumption - advanced reporting

I love the energy features that have been introduced into Home Assistant and I’ve been collecting data for just under a year. I can see the charts for daily/weekly/monthly usage and that’s all working great.

But I was wondering whether it’s possible to generate more detailed reports than what’s available through lovelace?

For example, average usage at each hour of the day? Or average usage on particular days?

If not, I was wondering what the best way to do this might be… I’d heard that using InfluxDB to collect the raw data might be an option as that will give me the ability to query it directly. Does that sound sensible?

And, if I did start using InfluxDB, would I be able to migrate over the existing data somehow or would I need to start afresh?

Just trying to familiarise myself with it all so thanks, in advance, for any advice.