### What happened?
I configured a time series panel to use a relative time (now…-1y) independent from the time picker in the dashboard. However the panel keeps switching between 2 states: A correct state with the relative time respected and a state where the dashboards time range (Last 6 hours) is used.
I was under the impression that this is dependent from the auto refresh of the dashboard. This was configured to 10s.
Grafana does not show any error message.
In the case where the dashboards time ragen is used in the panel, it still displays a specific time range of "Last 1 Year" in the panel which contradict the shown contents.
### What did you expect to happen?
The relative time range of the panel must be respected even with "Last 6 hours" set in the dashboard at all times.
### Did this work before?
It did never work before. Actually I checked with Versions 10.2.3, 10.2.8, 10.3 and 11.1.2 (latest at the time of this bug report).
### How do we reproduce it?
1. Create a time series panel
2. In the query options configure a specific relative time of "now-1y" (although this happened with other configurations just the same)
3. Set the dashboard to a default time range of 6 hours and auto refresh to 10s, save the dashboard.
4. Open the dashboard, watch panel change states automatically.
### Is the bug inside a dashboard panel?
| Key | Value |
|--|--|
| Panel | timeseries @ 10.1.0 |
| Grafana | Grafana v11.1.2 (2c084e6113) // Open Source |
<details><summary>Panel debug snapshot dashboard</summary>
```json
{
"panels": [
{
"datasource": {
"type": "grafana",
"uid": "grafana"
},
"description": "Entwicklung des Gesundheitszustandes der Batterie über die Zeit.\nHealth stellt den Anteil der verbleibenden Kapazität der Sollkapazität dar.\nDie Anzahl der Ladezyklen gibt an, wie oft eine Energiemenge entsprechend der Sollkapazität in die Batterie geladen wurde.\nDer Wirkungsgrad ist der Anteil der geladenen Energie, den die Batterie wieder abgeben kann.",
"fieldConfig": {
"defaults": {
"custom": {
"drawStyle": "line",
"lineInterpolation": "smooth",
"barAlignment": 0,
"lineWidth": 1,
"fillOpacity": 0,
"gradientMode": "none",
"spanNulls": true,
"insertNulls": false,
"showPoints": "never",
"pointSize": 5,
"stacking": {
"mode": "none",
"group": "A"
},
"axisPlacement": "auto",
"axisLabel": "",
"axisColorMode": "text",
"axisBorderShow": false,
"scaleDistribution": {
"type": "linear"
},
"axisCenteredZero": false,
"hideFrom": {
"tooltip": false,
"viz": false,
"legend": false
},
"thresholdsStyle": {
"mode": "off"
}
},
"color": {
"mode": "palette-classic"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "percent"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Load Cycles"
},
"properties": [
{
"id": "unit",
"value": "none"
}
]
}
]
},
"gridPos": {
"h": 13,
"w": 15,
"x": 0,
"y": 0
},
"hideTimeOverride": false,
"id": 2,
"options": {
"tooltip": {
"mode": "multi",
"sort": "none"
},
"legend": {
"showLegend": true,
"displayMode": "table",
"placement": "right",
"calcs": [
"lastNotNull"
]
}
},
"pluginVersion": "10.1.0",
"targets": [
{
"refId": "A",
"datasource": {
"type": "grafana",
"uid": "grafana"
},
"queryType": "snapshot",
"snapshot": [
{
"schema": {
"refId": "Batterie Gesundheit",
"meta": {
"typeVersion": [
0,
0
],
"executedQueryString": "taskstart = 2024-02-26T00:00:00Z\n\nfrom(bucket: \"pv_lt\")\n |> range(start: taskstart)\n |> filter(fn: (r) => r._field == \"battery_state_of_healthy\" or r._field == \"battery_load_cycles\" or r._field == \"battery_total_charge_efficiency\")\n |> aggregateWindow(every: 1d, fn: mean)\n"
},
"name": "sungrow",
"fields": [
{
"name": "Time",
"type": "time",
"typeInfo": {
"frame": "time.Time",
"nullable": true
},
"config": {}
},
{
"name": "battery_load_cycles",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"labels": {},
"config": {}
}
]
},
"data": {
"values": [
[
1708992000000,
1709078400000,
1709164800000,
1709251200000,
1709337600000,
1709424000000,
1709510400000,
1709596800000,
1709683200000,
1709769600000,
1709856000000,
1709942400000,
1710028800000,
1710115200000,
1710201600000,
1710288000000,
1710374400000,
1710460800000,
1710547200000,
1710633600000,
1710720000000,
1710806400000,
1710892800000,
1710979200000,
1711065600000,
1711152000000,
1711238400000,
1711324800000,
1711411200000,
1711497600000,
1711584000000,
1711670400000,
1711756800000,
1711843200000,
1711929600000,
1712016000000,
1712102400000,
1712188800000,
1712275200000,
1712361600000,
1712448000000,
1712534400000,
1712620800000,
1712707200000,
1712793600000,
1712880000000,
1712966400000,
1713052800000,
1713139200000,
1713225600000,
1713312000000,
1713398400000,
1713484800000,
1713571200000,
1713657600000,
1713744000000,
1713830400000,
1713916800000,
1714003200000,
1714089600000,
1714176000000,
1714262400000,
1714348800000,
1714435200000,
1714521600000,
1714608000000,
1714694400000,
1714780800000,
1714867200000,
1714953600000,
1715040000000,
1715126400000,
1715212800000,
1715299200000,
1715385600000,
1715472000000,
1715558400000,
1715644800000,
1715731200000,
1715817600000,
1715904000000,
1715990400000,
1716076800000,
1716163200000,
1716249600000,
1716336000000,
1716422400000,
1716508800000,
1716595200000,
1716681600000,
1716768000000,
1716854400000,
1716940800000,
1717027200000,
1717113600000,
1717200000000,
1717286400000,
1717372800000,
1717459200000,
1717545600000,
1717632000000,
1717718400000,
1717804800000,
1717891200000,
1717977600000,
1718064000000,
1718150400000,
1718236800000,
1718323200000,
1718409600000,
1718496000000,
1718582400000,
1718668800000,
1718755200000,
1718841600000,
1718928000000,
1719014400000,
1719100800000,
1719187200000,
1719273600000,
1719360000000,
1719446400000,
1719532800000,
1719619200000,
1719705600000,
1719792000000,
1719878400000,
1719964800000,
1720051200000,
1720137600000,
1720224000000,
1720310400000,
1720396800000,
1720483200000,
1720569600000,
1720656000000,
1720742400000,
1720828800000,
1720915200000,
1721001600000,
1721088000000,
1721174400000,
1721260800000,
1721347200000,
1721433600000,
1721520000000,
1721606400000,
1721692800000,
1721779200000,
1721865600000,
1721952000000,
1722038400000,
1722053686728
],
[
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
40.94,
41.63,
42.25,
42.82,
43.34,
43.78,
44.67,
45.45,
46.09,
46.92,
47.58,
48.35,
49,
49.75,
50.6,
51.01,
51.56,
52.06,
52.62,
53.36,
53.97,
54.49,
55.17,
55.73,
56.31,
56.8,
57.7,
58.34,
58.98,
59.78,
60.53,
61.23,
61.76,
62.28,
62.89,
63.44,
64.04,
64.92,
65.55,
66.06,
66.43,
66.85,
67.31,
67.79,
68.46,
69.07,
69.62,
70.31,
70.97,
71.6,
72.24,
72.8,
73.55,
74.16,
74.79,
75.43,
76,
76.86,
77.28,
77.64,
77.95,
78.32,
78.8,
79.17,
79.56,
80.33,
81.07,
81.8,
82.38,
82.96,
83.35,
83.81,
84.75,
85.27,
85.75,
86.25,
86.84,
87.47,
88.02,
88.55,
89.12,
89.75,
90.25,
90.67,
91.05,
91.73,
92.25,
92.74,
93.28,
93.97,
94.63,
95.38,
null
]
],
"nanos": [
[
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
726238
],
null
]
}
},
{
"schema": {
"refId": "Batterie Gesundheit",
"name": "sungrow",
"fields": [
{
"name": "Time",
"type": "time",
"typeInfo": {
"frame": "time.Time",
"nullable": true
},
"config": {}
},
{
"name": "battery_state_of_healthy",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"labels": {},
"config": {}
}
]
},
"data": {
"values": [
[
1708992000000,
1709078400000,
1709164800000,
1709251200000,
1709337600000,
1709424000000,
1709510400000,
1709596800000,
1709683200000,
1709769600000,
1709856000000,
1709942400000,
1710028800000,
1710115200000,
1710201600000,
1710288000000,
1710374400000,
1710460800000,
1710547200000,
1710633600000,
1710720000000,
1710806400000,
1710892800000,
1710979200000,
1711065600000,
1711152000000,
1711238400000,
1711324800000,
1711411200000,
1711497600000,
1711584000000,
1711670400000,
1711756800000,
1711843200000,
1711929600000,
1712016000000,
1712102400000,
1712188800000,
1712275200000,
1712361600000,
1712448000000,
1712534400000,
1712620800000,
1712707200000,
1712793600000,
1712880000000,
1712966400000,
1713052800000,
1713139200000,
1713225600000,
1713312000000,
1713398400000,
1713484800000,
1713571200000,
1713657600000,
1713744000000,
1713830400000,
1713916800000,
1714003200000,
1714089600000,
1714176000000,
1714262400000,
1714348800000,
1714435200000,
1714521600000,
1714608000000,
1714694400000,
1714780800000,
1714867200000,
1714953600000,
1715040000000,
1715126400000,
1715212800000,
1715299200000,
1715385600000,
1715472000000,
1715558400000,
1715644800000,
1715731200000,
1715817600000,
1715904000000,
1715990400000,
1716076800000,
1716163200000,
1716249600000,
1716336000000,
1716422400000,
1716508800000,
1716595200000,
1716681600000,
1716768000000,
1716854400000,
1716940800000,
1717027200000,
1717113600000,
1717200000000,
1717286400000,
1717372800000,
1717459200000,
1717545600000,
1717632000000,
1717718400000,
1717804800000,
1717891200000,
1717977600000,
1718064000000,
1718150400000,
1718236800000,
1718323200000,
1718409600000,
1718496000000,
1718582400000,
1718668800000,
1718755200000,
1718841600000,
1718928000000,
1719014400000,
1719100800000,
1719187200000,
1719273600000,
1719360000000,
1719446400000,
1719532800000,
1719619200000,
1719705600000,
1719792000000,
1719878400000,
1719964800000,
1720051200000,
1720137600000,
1720224000000,
1720310400000,
1720396800000,
1720483200000,
1720569600000,
1720656000000,
1720742400000,
1720828800000,
1720915200000,
1721001600000,
1721088000000,
1721174400000,
1721260800000,
1721347200000,
1721433600000,
1721520000000,
1721606400000,
1721692800000,
1721779200000,
1721865600000,
1721952000000,
1722038400000,
1722053686728
],
[
null,
100,
100,
100,
100,
null,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
null,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
100,
99.5,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
99,
null
]
],
"nanos": [
[
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
726238
],
null
]
}
},
{
"schema": {
"refId": "Batterie Gesundheit",
"name": "sungrow",
"fields": [
{
"name": "Time",
"type": "time",
"typeInfo": {
"frame": "time.Time",
"nullable": true
},
"config": {}
},
{
"name": "battery_total_charge_efficiency",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"labels": {},
"config": {}
}
]
},
"data": {
"values": [
[
1708992000000,
1709078400000,
1709164800000,
1709251200000,
1709337600000,
1709424000000,
1709510400000,
1709596800000,
1709683200000,
1709769600000,
1709856000000,
1709942400000,
1710028800000,
1710115200000,
1710201600000,
1710288000000,
1710374400000,
1710460800000,
1710547200000,
1710633600000,
1710720000000,
1710806400000,
1710892800000,
1710979200000,
1711065600000,
1711152000000,
1711238400000,
1711324800000,
1711411200000,
1711497600000,
1711584000000,
1711670400000,
1711756800000,
1711843200000,
1711929600000,
1712016000000,
1712102400000,
1712188800000,
1712275200000,
1712361600000,
1712448000000,
1712534400000,
1712620800000,
1712707200000,
1712793600000,
1712880000000,
1712966400000,
1713052800000,
1713139200000,
1713225600000,
1713312000000,
1713398400000,
1713484800000,
1713571200000,
1713657600000,
1713744000000,
1713830400000,
1713916800000,
1714003200000,
1714089600000,
1714176000000,
1714262400000,
1714348800000,
1714435200000,
1714521600000,
1714608000000,
1714694400000,
1714780800000,
1714867200000,
1714953600000,
1715040000000,
1715126400000,
1715212800000,
1715299200000,
1715385600000,
1715472000000,
1715558400000,
1715644800000,
1715731200000,
1715817600000,
1715904000000,
1715990400000,
1716076800000,
1716163200000,
1716249600000,
1716336000000,
1716422400000,
1716508800000,
1716595200000,
1716681600000,
1716768000000,
1716854400000,
1716940800000,
1717027200000,
1717113600000,
1717200000000,
1717286400000,
1717372800000,
1717459200000,
1717545600000,
1717632000000,
1717718400000,
1717804800000,
1717891200000,
1717977600000,
1718064000000,
1718150400000,
1718236800000,
1718323200000,
1718409600000,
1718496000000,
1718582400000,
1718668800000,
1718755200000,
1718841600000,
1718928000000,
1719014400000,
1719100800000,
1719187200000,
1719273600000,
1719360000000,
1719446400000,
1719532800000,
1719619200000,
1719705600000,
1719792000000,
1719878400000,
1719964800000,
1720051200000,
1720137600000,
1720224000000,
1720310400000,
1720396800000,
1720483200000,
1720569600000,
1720656000000,
1720742400000,
1720828800000,
1720915200000,
1721001600000,
1721088000000,
1721174400000,
1721260800000,
1721347200000,
1721433600000,
1721520000000,
1721606400000,
1721692800000,
1721779200000,
1721865600000,
1721952000000,
1722038400000,
1722053686728
],
[
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
88.49,
88.78,
88.78,
88.76,
88.71,
88.6,
89.32,
89.16,
89.02,
89.21,
89.04,
89.36,
89.01,
89.17,
89.38,
88.74,
89.01,
88.91,
89.04,
89.33,
89.07,
89.46,
89.28,
89.1,
89.14,
89.37,
89.58,
89.31,
89.29,
89.35,
89.56,
89.33,
89.21,
89.1,
89.28,
89.32,
89.63,
89.77,
89.51,
89.34,
89.1,
89.16,
89.2,
89.17,
89.4,
89.42,
89.31,
89.51,
89.5,
89.36,
89.48,
89.4,
89.66,
89.48,
89.51,
89.54,
89.42,
89.72,
89.31,
89.22,
89.16,
89.18,
89.32,
89.16,
89.29,
89.59,
89.51,
89.55,
89.37,
89.38,
89.24,
89.42,
89.76,
89.34,
89.34,
89.36,
89.41,
89.49,
89.38,
89.38,
89.45,
89.49,
89.4,
89.31,
89.3,
89.53,
89.44,
89.36,
89.43,
89.59,
89.505,
89.495,
null
]
],
"nanos": [
[
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
726238
],
null
]
}
}
]
}
],
"timeFrom": "now-1y",
"title": "Reproduced with embedded data",
"transformations": [
{
"id": "joinByField",
"options": {}
},
{
"id": "organize",
"options": {
"excludeByName": {
"Time": false
},
"includeByName": {},
"indexByName": {},
"renameByName": {
"battery_load_cycles sungrow": "Load Cycles",
"battery_state_of_healthy sungrow": "State of Healthy (SoH)",
"battery_state_of_healthy {name=\"sungrow\"}": "Batterie Health",
"battery_total_charge_efficiency sungrow": "Total Charge Efficiency",
"sungrow 1": "Wirkungsgrad",
"sungrow 2": "Ladezyklen"
}
}
}
],
"type": "timeseries"
},
{
"gridPos": {
"h": 7,
"w": 9,
"x": 15,
"y": 0
},
"id": 5,
"options": {
"content": "<table width=\"100%\">\n <tr>\n <th width=\"2%\">Panel</th>\n <td >timeseries @ 10.1.0</td>\n </tr>\n <tr>\n <th>Queries</th>\n <td>Batterie Gesundheit[influxdb]</td>\n </tr>\n <tr>\n <th>Transform</th>\n <td>joinByField, organize</td>\n </tr>\n <tr><th>Data</th><td> 3 frames, 6 fields, 459 rows </td></tr>\n \n <tr>\n <th>Grafana</th>\n <td>Grafana v11.1.2 (2c084e6113) // Open Source</td>\n </tr>\n </table>",
"mode": "html"
},
"title": "Debug info",
"type": "text"
},
{
"id": 6,
"title": "Original Panel JSON",
"type": "text",
"gridPos": {
"h": 13,
"w": 9,
"x": 15,
"y": 7
},
"options": {
"content": "{\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"DS_INFLUXDB2\"\n },\n \"description\": \"Entwicklung des Gesundheitszustandes der Batterie über die Zeit.\\nHealth stellt den Anteil der verbleibenden Kapazität der Sollkapazität dar.\\nDie Anzahl der Ladezyklen gibt an, wie oft eine Energiemenge entsprechend der Sollkapazität in die Batterie geladen wurde.\\nDer Wirkungsgrad ist der Anteil der geladenen Energie, den die Batterie wieder abgeben kann.\",\n \"fieldConfig\": {\n \"defaults\": {\n \"custom\": {\n \"drawStyle\": \"line\",\n \"lineInterpolation\": \"smooth\",\n \"barAlignment\": 0,\n \"lineWidth\": 1,\n \"fillOpacity\": 0,\n \"gradientMode\": \"none\",\n \"spanNulls\": true,\n \"insertNulls\": false,\n \"showPoints\": \"never\",\n \"pointSize\": 5,\n \"stacking\": {\n \"mode\": \"none\",\n \"group\": \"A\"\n },\n \"axisPlacement\": \"auto\",\n \"axisLabel\": \"\",\n \"axisColorMode\": \"text\",\n \"axisBorderShow\": false,\n \"scaleDistribution\": {\n \"type\": \"linear\"\n },\n \"axisCenteredZero\": false,\n \"hideFrom\": {\n \"tooltip\": false,\n \"viz\": false,\n \"legend\": false\n },\n \"thresholdsStyle\": {\n \"mode\": \"off\"\n }\n },\n \"color\": {\n \"mode\": \"palette-classic\"\n },\n \"mappings\": [],\n \"thresholds\": {\n \"mode\": \"absolute\",\n \"steps\": [\n {\n \"color\": \"green\",\n \"value\": null\n }\n ]\n },\n \"unit\": \"percent\"\n },\n \"overrides\": [\n {\n \"matcher\": {\n \"id\": \"byName\",\n \"options\": \"Load Cycles\"\n },\n \"properties\": [\n {\n \"id\": \"unit\",\n \"value\": \"none\"\n }\n ]\n }\n ]\n },\n \"gridPos\": {\n \"h\": 9,\n \"w\": 19,\n \"x\": 0,\n \"y\": 27\n },\n \"hideTimeOverride\": false,\n \"id\": 258,\n \"options\": {\n \"tooltip\": {\n \"mode\": \"multi\",\n \"sort\": \"none\"\n },\n \"legend\": {\n \"showLegend\": true,\n \"displayMode\": \"table\",\n \"placement\": \"right\",\n \"calcs\": [\n \"lastNotNull\"\n ]\n }\n },\n \"pluginVersion\": \"10.1.0\",\n \"targets\": [\n {\n \"datasource\": {\n \"type\": \"influxdb\",\n \"uid\": \"DS_INFLUXDB2\"\n },\n \"query\": \"taskstart = 2024-02-26T00:00:00Z\\n\\nfrom(bucket: \\\"pv_lt\\\")\\n |> range(start: taskstart)\\n |> filter(fn: (r) => r._field == \\\"battery_state_of_healthy\\\" or r._field == \\\"battery_load_cycles\\\" or r._field == \\\"battery_total_charge_efficiency\\\")\\n |> aggregateWindow(every: 1d, fn: mean)\\n\",\n \"rawQuery\": true,\n \"refId\": \"Batterie Gesundheit\",\n \"resultFormat\": \"time_series\"\n }\n ],\n \"timeFrom\": \"now-1y\",\n \"title\": \"Batterie Health\",\n \"transformations\": [\n {\n \"id\": \"joinByField\",\n \"options\": {}\n },\n {\n \"id\": \"organize\",\n \"options\": {\n \"excludeByName\": {\n \"Time\": false\n },\n \"includeByName\": {},\n \"indexByName\": {},\n \"renameByName\": {\n \"battery_load_cycles sungrow\": \"Load Cycles\",\n \"battery_state_of_healthy sungrow\": \"State of Healthy (SoH)\",\n \"battery_state_of_healthy {name=\\\"sungrow\\\"}\": \"Batterie Health\",\n \"battery_total_charge_efficiency sungrow\": \"Total Charge Efficiency\",\n \"sungrow 1\": \"Wirkungsgrad\",\n \"sungrow 2\": \"Ladezyklen\"\n }\n }\n }\n ],\n \"type\": \"timeseries\"\n}",
"mode": "code",
"code": {
"language": "json",
"showLineNumbers": true,
"showMiniMap": true
}
}
},
{
"id": 3,
"title": "Data from panel above (after transformations)",
"type": "table",
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"gridPos": {
"h": 7,
"w": 15,
"x": 0,
"y": 13
},
"options": {
"showTypeIcons": true
},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"panelId": 2,
"withTransforms": true,
"refId": "A"
}
]
},
{
"id": 100,
"title": "Data (before transformations)",
"type": "table",
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"gridPos": {
"h": 7,
"w": 24,
"x": 0,
"y": 13
},
"options": {
"showTypeIcons": true
},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "-- Dashboard --"
},
"panelId": 2,
"withTransforms": false,
"refId": "A"
}
]
}
],
"schemaVersion": 37,
"title": "Debug: Batterie Health // 2024-07-27 06:14:50",
"tags": [
"debug",
"debug-timeseries"
],
"time": {
"from": "2024-07-26T22:14:50.288Z",
"to": "2024-07-27T04:14:50.288Z"
}
}
```
</details>
### Environment (with versions)?
Grafana: v11.1.2
OS: Debian on a Raspberry Pi 4
Browser: Safari
### Grafana platform?
Docker
### Datasource(s)?
Data source is InfluxDB, the query is Flux, which seems to works as expected.