Operato Windrose not working with InfluxDB?

I’m trying to get this plugin working - Operato Windrose plugin for Grafana | Grafana Labs
As far as I can tell everything is configured as it should be
These are my queries:
SELECT last("wind_speed") AS wind_speed FROM "weather" WHERE ("city"::tag = 'winchester') AND $timeFilter GROUP BY time($__interval) fill(none)
SELECT last("wind_direction") AS wind_direction FROM "weather" WHERE ("city"::tag = 'winchester') AND $timeFilter GROUP BY time($__interval) fill(none)
I have lots of data which is visible in the ‘table view’, but nothing is showing in the windrose

Does anyone have this working with InfluxDB (SQL), or any suggestions?
Equally - does anyone I know where I can raise an issue with the author
Thanks

1 Like

Hi!
I had same issue, and I partially solved using transformation.
I’m using grafana on Home Assistant docker, hence not sure if will act the same.
But basically as I understood the plugin is expecting a table with
| timestamp | wind_speed | wind_direction |
What I had was 2 table, one with
| timestamp | wind_speed |
and secon one with
| timestamp | wind_direction |

So using a transformation “concatenate fields”, using option “Copy frame name to field name” as result I had proper table, and the panel has a better view


Moreover if you filter result removing null values, you should have a good overall result

I still finalising the setup, but better then not working one, hope will help :smiley:

1 Like

Nice! I used ‘Join by Field’ which works well for me - but looks my data source is a bit flaky - data is quite sparse, but thanks for the pointer on getting this working

I am using InfluxDB with Flux as datasource, and Operato Windrose plugin is also working:

Just needed to pivot data and rename columns:

I simplified this with a single Influx (1.8) InfluxQL query - note that this is formatted as ‘table’ not timeseries