Time series transformed reduced row bar size is not adjustable

Grafana
,
1

Hi everyone!
For a time series I use transformations/reduce rows to merge 3 influxdb sources. For the resulting field (Rain) I cannot adjust the bar-with factor, whereas for the non-transformed data this is working.
Using transformation:

image
image429×679 3.45 KB

Non transformed data (rain per24h)
image
image1184×659 5.39 KB

Any idea how to make the transformed bar wider?

Greetings,
mcmuller

2

can you please share a sanitized table view of your data?

3

@sowdenraymond thanks for looking into this!
hope this is what you asked for:

image
image1525×1518 167 KB

…while selecting the above i found out that disabling all other queries, exept the ones I transform (rain 1,2,3), results in a nice bar chart:

image
image1527×1636 231 KB

as soon, as I enable back another query the problem shows up again:

image
image1540×1545 216 KB

All other queries are lines, the “rain” ist the only bar

Greetings,
mcmuller

4

can you post sample data (not screen shot) of 10 rows of rain and 10 corresponding rows of soil like this

datetime,type,measurement
2025-02-13 13:33:33,rain,55
2025-02-13 13:33:33,soil,1

also are both values measure in mm?

5

I’ve added a sample from all queries, “rain” is transformed from “Reduce Row/Total” of three Rain-queries:

"Time","Soil moisture Melanosporum","Temperature Melanosporum 30cm","Temperature Melanosporum Groundlevel","Soil conductivity Melanosporum","Rain"
11.02.2025 20:55:00,31.3 %H,14.8 °C,13.8 °C,331 µS/cm,0 mm
11.02.2025 21:15:00,31.3 %H,14.8 °C,13.6 °C,331 µS/cm,0 mm
11.02.2025 21:35:00,31.2 %H,14.8 °C,13.5 °C,330 µS/cm,0 mm
11.02.2025 21:55:00,31.2 %H,14.8 °C,13.3 °C,329 µS/cm,0 mm
11.02.2025 22:15:00,31.2 %H,14.8 °C,13.3 °C,329 µS/cm,0 mm
11.02.2025 22:35:00,31.2 %H,14.7 °C,13.1 °C,328 µS/cm,0 mm
11.02.2025 22:55:00,31.1 %H,14.7 °C,13.1 °C,328 µS/cm,0 mm
11.02.2025 23:15:00,31.1 %H,14.7 °C,13 °C,328 µS/cm,0 mm
11.02.2025 23:35:00,31.1 %H,14.7 °C,12.8 °C,328 µS/cm,0 mm
11.02.2025 23:55:00,31.1 %H,14.7 °C,12.7 °C,327 µS/cm,0 mm
12.02.2025 00:00:00,,,,,12.0 mm
12.02.2025 00:15:00,31.0 %H,14.7 °C,12.5 °C,327 µS/cm,0 mm
12.02.2025 00:35:00,31.0 %H,14.7 °C,12.5 °C,326 µS/cm,0 mm
12.02.2025 00:55:00,31.0 %H,14.6 °C,12.5 °C,326 µS/cm,0 mm
12.02.2025 01:15:00,31.0 %H,14.6 °C,12.5 °C,326 µS/cm,0 mm
12.02.2025 01:35:00,31.0 %H,14.6 °C,12.5 °C,326 µS/cm,0 mm
12.02.2025 01:55:00,30.9 %H,14.6 °C,12.5 °C,325 µS/cm,0 mm
12.02.2025 02:15:00,30.9 %H,14.5 °C,12.4 °C,325 µS/cm,0 mm
6

can you please reduce your data to just rain and soil you had on your visualization.

also please provide the raw data before any transformation.

7 
"Time","Soil conductivity Melanosporum","Rain2","Rain3"
1738880100000,293,undefined,undefined
1738881300000,293,undefined,undefined
1738882500000,293,undefined,undefined
1738883700000,293,undefined,undefined
1738884900000,293,undefined,undefined
1738886100000,293,undefined,undefined
1738886400000,undefined,undefined,1.2895384615384617
1738887300000,293,undefined,undefined
1738888500000,293,undefined,undefined
1738889700000,292,undefined,undefined
1738890900000,292,undefined,undefined
1738892100000,292,undefined,undefined
1738893300000,292,undefined,undefined
1738894500000,292,undefined,undefined
8

:rofl:

again please don’t pollute your posts with extras :fries: as detective Colombo used to say “Just the facts, ma’am”

:mushroom: