I have my electricity consumption being logged into influxdb. Every 10 minutes the total cumulative kWh used by my premises is logged into influxdb. Using Grafana I plot the difference between measurements to calculate how much consumption has happened during that period.
I am billed differently depending on what time and day of week I use electricity. As well as paying a set charge per day, there are these three tariffs for usage:
Peak: Monday-Friday 15:00-23:00
Shoulder: Monday-Friday 07:00-15:00
Off Peak: All other times
I would like to try to work out what proportion of my consumption falls within a particular tariff so I can drill further into my electricity consumption and further optimise my usage.
Can the combination of Influxdb and grafana return the accumulation of data for given times and days of week like the above?