I am using tibber and want to show energy prices for hourly interval
(last 12h and forward looking the next 24 hours) as a bar chart, which is working fine.
The only thing missing is that i would love to mark/highlight the current price. Annotations work fine as time series, but it seems they are not working in bar charts.
This is the sample query:
SELECT UNIXEPOCH(datetime(startsAt)) as time, total FROM tibber WHERE datetime(startsAt) BETWEEN datetime(‘now’,‘-12 hour’) AND datetime(‘now’,‘+24 hour’)
ORDER BY UNIXEPOCH(datetime(startsAt)) ASC
Anyone any ideas? (i tried things with override, but this took me nowhere…)
Grafana v11.4.0 (b58701869e)
OpenSource on Raspberry Debian
SQLLite Database