I want to create a dashboard where I can visually compare the historical consumption data against the entity status history in a chart.
series 1: historical hourly energy consumption totals
series 2 to n: historical on/off % values for various tuya lights and switches
I cannot create my energy consumption as sensor with history because i get the data from a provider xml which is always 1 day old. I cannot injest it on the day it happens.
I can however load the daily/hourly names and values into homeassistant as a sensor or an entity. I’m not sure what the sensor / entity should look like in order to be used to create series 1 above.
Should I add each day / hour as an attribute to a single entity? Can attributes as dates be parsed into a graph series later?
Should I just load the whole day/hour/totals as JSON into a state attribute? Can that be parse into a graph later?