Good Evening,
I am trying to use the Apex card to show my energy usage through out the day. It seems to be tracking the usage cumulatively, what I want it to show is that if everything comes on a 8am for example you see the spike in energy and then if it drops to 0 from 10 - 12 before another spike.
I have tried a few different ways based on the hacs guidance but cant seem to get it right. The code is below and would appreciate any help
type: custom:apexcharts-card
update_interval: 30min
graph_span: 24h
span:
start: day
header:
show: true
show_states: true
colorize_states: true
series:
- entity: sensor.electric_consumption_today
type: column
group_by:
func: sum