Spread and maths

1

I have a spread query and need to do a mathematical calculation on the value, how do I add the maths as the below don’t work.

SELECT spread(pulseNO*0.3) FROM weather_rain  WHERE $timeFilter GROUP BY time($__interval) fill(none)
2

Ok I found the solution, the only problem is now the time is out by 2h as I am in GMT+2

SELECT (spread(pulseNO)*0.3) FROM weather_rain  WHERE $timeFilter GROUP BY time(1d)

image
image1265×349 12.1 KB