Hello,
I was searching for a way to use Operato Windrose with Prometheus but did only find a closed (but not answered) topic at Cannot Get Operato Windrose Card To Work With Prometheus or InfluxDB.
Since I solved it, I just want to share it.
- create prometheus queries for wind speed and wind direction.
- change the legend to custom. The wind speed legend must be “wind_speed”, the direction “wind_direction”
- go to “Transformations” and add “join by field”. Join method is “OUTER”, field is “time”
The result is a table with 3 columns: time, wind_speed, wind_direction. It can be verified by selecting “table” as visualisation. After that, Operato Windrose can be used as visualisation and works.