-
What Grafana version and what operating system are you using?
Linux Ubuntu Server 22.04LTS -
What are you trying to achieve?
A time series with 2 data set -
How are you trying to achieve it?
I did a join by field + Organize field for rename -
What happened?
Y axis disappeared -
What did you expect to happen?
The graph keep the Y axis displayed. -
Can you copy/paste the configuration(s) that you are having problems with?
{
"id": 10,
"gridPos": {
"h": 11,
"w": 8,
"x": 16,
"y": 11
},
"type": "timeseries",
"title": "Wind Speed",
"transformations": [
{
"id": "joinByField",
"options": {
"byField": "Time",
"mode": "outer"
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {},
"renameByName": {
"value {host=\"test-apu\", name=\"mqtt_consumer\", topic=\"weather_station/sensor/CF5E27AD0E4D0942977985B6DAED103A/windgust/state\"}": "Wind Gust",
"value {host=\"test-apu\", name=\"mqtt_consumer\", topic=\"weather_station/sensor/CF5E27AD0E4D0942977985B6DAED103A/windspeed/state\"}": "Wind Speed"
}
}
}
],
"datasource": {
"type": "influxdb",
"uid": "BjAj1H1Vk"
},
"fieldConfig": {
"defaults": {
"custom": {
"drawStyle": "line",
"lineInterpolation": "smooth",
"barAlignment": 0,
"lineWidth": 3,
"fillOpacity": 0,
"gradientMode": "none",
"spanNulls": false,
"showPoints": "auto",
"pointSize": 5,
"stacking": {
"mode": "none",
"group": "A"
},
"axisPlacement": "left",
"axisLabel": "",
"axisColorMode": "text",
"scaleDistribution": {
"type": "linear"
},
"axisCenteredZero": false,
"hideFrom": {
"tooltip": false,
"viz": false,
"legend": false
},
"thresholdsStyle": {
"mode": "dashed"
},
"axisSoftMax": 150,
"axisSoftMin": 0,
"axisWidth": 2
},
"color": {
"mode": "palette-classic"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 120
}
]
},
"unit": "velocityms"
},
"overrides": []
},
"options": {
"tooltip": {
"mode": "multi",
"sort": "none"
},
"legend": {
"showLegend": true,
"displayMode": "table",
"placement": "bottom",
"calcs": [
"max",
"min",
"mean"
]
}
},
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "BjAj1H1Vk"
},
"query": "from(bucket: \"test_mqtt\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"mqtt_consumer\")\r\n |> filter(fn: (r) => r[\"topic\"] == \"weather_station/sensor/CF5E27AD0E4D0942977985B6DAED103A/windgust/state\" or r[\"topic\"] == \"weather_station/sensor/CF5E27AD0E4D0942977985B6DAED103A/windspeed/state\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")\r\n ",
"refId": "A"
}
]
}
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
No errors
- Did you follow any online instructions? If so, what is the URL?