Using Operato Windrose with Prometheus

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.

  1. create prometheus queries for wind speed and wind direction.
  2. change the legend to custom. The wind speed legend must be “wind_speed”, the direction “wind_direction”
  3. 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.