- What Grafana version and what operating system are you using?
Home Assistant Add-On, Grafana Version 11.6.9 - What are you trying to achieve?
I am trying to use the Operato Windrose plugin for my wind data (collected by Home Assistant and saved in InfluxDB) - How are you trying to achieve it?
I currently have the following two queries:
SELECT mean("value") FROM "km/h" WHERE ("entity_id"::tag = 'gw1100a_wind_gust') AND $timeFilter GROUP BY time($__interval) fill(null)
and
SELECT mean("value") FROM "°" WHERE ("entity_id"::tag = 'gw1100a_wind_direction') AND $timeFilter GROUP BY time($__interval) fill(null)
But I don’t know how to get both into one frame with the correct variable names like in the instructions here…
-
What happened?
It did not work (Screenshot attached)
-
What did you expect to happen?
It should have displayed the data -
Can you copy/paste the configuration(s) that you are having problems with?
{
"id": 3,
"type": "operato-windrose-panel",
"title": "Panel Title",
"gridPos": {
"x": 0,
"y": 0,
"h": 8,
"w": 12
},
"fieldConfig": {
"defaults": {},
"overrides": []
},
"transformations": [],
"pluginVersion": "1.2.0",
"targets": [
{
"refId": "A",
"policy": "default",
"resultFormat": "time_series",
"orderByTime": "ASC",
"tags": [
{
"key": "entity_id::tag",
"value": "gw1100a_wind_direction",
"operator": "="
}
],
"groupBy": [
{
"type": "time",
"params": [
"$__interval"
]
},
{
"type": "fill",
"params": [
"null"
]
}
],
"select": [
[
{
"type": "field",
"params": [
"value"
]
},
{
"type": "mean",
"params": []
}
]
],
"measurement": "°",
"alias": "direction",
"query": "SELECT mean(\"value\") FROM \"°\" WHERE (\"entity_id\"::tag = 'gw1100a_wind_direction') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true
},
{
"refId": "B",
"policy": "default",
"resultFormat": "time_series",
"orderByTime": "ASC",
"tags": [
{
"key": "entity_id::tag",
"value": "gw1100a_wind_gust",
"operator": "="
}
],
"groupBy": [
{
"type": "time",
"params": [
"$__interval"
]
},
{
"type": "fill",
"params": [
"null"
]
}
],
"select": [
[
{
"type": "field",
"params": [
"value"
]
},
{
"type": "mean",
"params": []
}
]
],
"measurement": "km/h",
"hide": false,
"datasource": {
"uid": "eejn8ecji1rlsd",
"type": "influxdb"
},
"alias": "speed",
"query": "SELECT mean(\"value\") FROM \"km/h\" WHERE (\"entity_id\"::tag = 'gw1100a_wind_gust') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": true
}
],
"datasource": {
"uid": "eejn8ecji1rlsd",
"type": "influxdb"
},
"options": {
"colorPalette": "default",
"petalsPer90Deg": 4,
"speedBucketsCount": 8,
"speedBucketsSizeAuto": true,
"speedBucketsSize": 2,
"tooltipDecimalPlaces": 1,
"windSpeedUnit": "ms",
"windroseLabels": "compass",
"cardinalLabels": "cardinal",
"showLegend": true,
"doesLegendOverlay": false,
"legendPosition": "right",
"legendAnchor": "bottom"
}
}
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
There are no errors - Did you follow any online instructions? If so, what is the URL?
Operato Windrose plugin for Grafana | Grafana Labs
However, I don’t know how to get one frame with wind_speed and wind_direction variables but I currently have two frames and don’t know how to set variable names