Usable Data from Home Assistant

As well as EMON CMS I have a Desktop server running home assistant that generates me some stats.

I am looking to integrate in the data from the heat pump into this

I get daily reports in the following format - example
Snag_2f41e6

I am looking to create the following but need to get these entities into my home assistant to do this and create the results in a table format like above

Ideally would like to see following broken down by live view, every 30 mins on the hour and 30 mins past the hour, daily, monthly.

PV generated kWh
Battery / in and out kWh
Grid / in and out kWh
Heat Pump Consumption kWh Hot Water
Heat Pump Generated kWh Hot Water
Immersion Eddi Consumption kWh
Hot Water COP
Heat Pump Consumption kWh Radiators house heating
Heat Pump Generated kWh Radiator house heating
Space Heating COP
Outside Temperature Celcius
Other Electric Consumption kWh
Total Electric Consumption House Load kWh

Not really sure how I go about getting the EmonCMS data into my other server to show this, can anyone help me?

Check out Emoncms - Home Assistant - that seems to provide EmonCMS → HA integration.

Yes imported these but nothing is showing the daily output or the half hourly.

I was looking into utility meters in home assistant but not even sure I have the right entities to work this back

energy_heatpump_out_today:
name: “Energy HP Out Today”
source: sensor.emoncms_electric_energy
cycle: daily

energy_heatpump_in_today:
name: “Energy HP In Today”
source: sensor.emoncms_electric_power
cycle: daily

Well that failed

Logger: homeassistant.components.sensor
Source: components/sensor/init.py:570
integration: Sensor (documentation, issues)
First occurred: 26 May 2024 at 10:20:49 (2 occurrences)
Last logged: 26 May 2024 at 10:20:49

  • Entity sensor.energy_hp_in_today (<class ‘homeassistant.components.utility_meter.sensor.UtilityMeterSensor’>) is using state class ‘total_increasing’ which is impossible considering device class (‘power’) it is using; expected None or one of ‘measurement’; Please update your configuration if your entity is manually configured, otherwise create a bug report at Issues · home-assistant/core · GitHub
  • Entity sensor.energy_hp_out_today (<class ‘homeassistant.components.utility_meter.sensor.UtilityMeterSensor’>) is using state class ‘total_increasing’ which is impossible considering device class (‘power’) it is using; expected None or one of ‘measurement’; Please update your configuration if your entity is manually configured, otherwise create a bug report at Issues · home-assistant/core · GitHub

What’s in your configuration.yaml file?

Have you set the Units in emonCMS? If not it defaults to W.