I want to create a bar chart, which shows the electricity price for the next day for each hour.
The values for each hour are saved in separate measurements, so I have 24: price_tomorrow_hour0, price_tomorrow_hour1, …, price_tomorrow_hour23.
So its not a time series, but 24 bars in the bar diagram with the latest values in the measurements.
Any ideas?
Datasource: InfluxDB
Grafana: 9.2.3
OS: Openhabian/ Raspbian GNU/Linux 10
Welcome
Version of grafan:
OS grafana is hosted on:
data source:
Some sample data would help forum help you
Sample data:
price_tomorrow_hour0=10.6
price_tomorrow_hour1=9.71
price_tomorrow_hour2=9.6
price_tomorrow_hour3=9.02
price_tomorrow_hour4=9.56
price_tomorrow_hour5=10.9
price_tomorrow_hour6=14.2
price_tomorrow_hour7=16.4
price_tomorrow_hour8=17.0
…
price_tomorrow_hour23=7.12
Thanks!
Version of grafana:
OS grafana is hosted on:
data source: mysql, sql sever? api?
