I have created a custom sensor (in this case sensor.nordpool_average), which is updated on a daily basis of the daily electric cost. I can access the history of this sensor and see the history, but I would like to get the average (see example).
Is there any way to do this, i.e. create a custom component which takes the history of sensor.nordpool_avreage since start of month up to current day and calculates the average?