I have a spot price electricity, the price changes every hour. I have this price information in grafana (influxdb). I have also my energy consumption there but I can’t figure out how to calculate the total price for a specific time range. For example, if I want to see the total costs for a 5 hour …

Calculate electricity price for a time range using spot prices

grant2 November 19, 2023, 12:53am 2

Are you using Flux or InfluxQL?

Here is a solution using Flux.