Hello dear Grafana users. I’m not quite sure where my question fits in, so I’ll put it here.
In Spain, electricity prices vary every hour. I download prices for the following day from the internet and dump the information in a text file. I then select the price from the corresponding text file line number according the the time of day, and pass it on to influxdb. I can then see the current price from a grafana dashboard.
I want to calculate the the cost of the electricity I use from the power grid. I of course have the grid power consumption measured and put into influxdb at 1 second intervals.
I have succesfully got grafana to show the past accumulated consumption for a 1 month period.
To calculate the price of the electricity I have used, the quickest solution would be to calculate the average electricity price and multiply by the accumulated consumption, but that wouldn’t be very accurate. I’m having trouble figuring out how to calculate the (more or less) accurate consumption with the data I have.
I hope I have explained myself well enough. I apologize if not.
Thank you very much.