I need some help with how i could implement a bill tracker.
I have a sensor setup to track the daily price for supply of energy and the two tracking costs (export and import).
I want to create a sensor that can show me the value (sum) of the three on my main dashboard. The catch is it needs to show this value since the 14th of each month, so the calculations need to show this based on when you are looking at the dashboard.
I thought it would be a good way to show what the current months bill is looking like.
Anyone have any ideas on how I can achieve this?