I have two panels showing me the total used kw/h over a day for each hour and also over the current month for each day.
Now I like to show also how much energy is used during low and high price.
So low price is during 22:00 and 06:00 and high price during 06:00 to 22:00.
With this Query I can display how much energy is used during a single day and with the value “now/M” in the relative time part it shows me this over the current month for each day in the month. (the shellyserverpm_power_0371 reports every 30 sec the current consumption)
SELECT $__timeGroupAlias(time,1d), sum(value)/120/1000 AS "server power consumption" FROM shellyserverpm_power_0371 WHERE $__timeFilter(time) GROUP BY 1 ORDER BY $__timeGroup(time,1d)
Now I like to show for each day how much energy is used during low and how much during high price.
Can someone give me a hint how to deal with this?