I’m a novice at Grafana but want to figure out how this is possible:
I’ve got an energy monitor that reports the current wattage consumed, the electricity rate tier, and the associated electricity rate in each tier. An example of the data:
I’d like to do the following:
Display a chart that shows the total cost per day for X days, X being the number of days selected by the time range selection. Each day would be a vertical bar, with color separation based on the amount of money spent on a given. Cost is calculated by getting the amount of watts used in a tier, converting to kilowatts by diving by 1000, then multiply it by the rate for that tier. Note that weekday tiers is at a different rate than weekend tiers.
Provide some kind of semi-intelligent estimation for the amount of energy that will be used in the remainder of the billing cycle. My cycle is currently every 6th of the month. I would like to be able to calculate it differently based on the day of the week as I imagine my weekday usage is pretty different than the weekend usage.