Household energy usage value exposed?

I have my energy dashboard setup to consider my solar (with battery) setup.

This makes it less simple to track my energy usage in the house becuase I need to consider solar input, battery charge levels (in/out) etc. This becomes a complex calculation.

I noticed that in the energy dashboardm this calculation is done for me - how can I access the value of this without doing the calculation myself:

exnergy

This value is held historically too and this is what I would like to access - is this value exposed in some way or will I need to use something like the sql sensor to calculate this value historically?

Thanks