Hi, using a raspberry pi streaming weather data to influxdb v1 then viewing that via grafana cloud.
I am using grafana to view weather data and it has been good. I want to calculate Wind Chill from Temperature + Wind Speed. This is the formula
T_wc = 13.12 + 0.6215 * Temperature * (0.3965 * Temperature - 11.37) * wind_speed^0.16
But as far as I can see, grafana can not calculate powers. The reason why i am not doing this on the Raspberry pi, is that this gets data from another Raspberry pi and this occauly has data gaps and then it will have the wrong wind chill and it saves storage in the database.
I would say there is many options and it depends only on you what’s acceptable for you.
One of them: use influxdb with flux, where is also pow function math.pow() function | Flux Documentation so you can calculate chill with flux query (that’s generally more efficient than doing any calculation on the a Grafana side), also you may exclude values, which are missing or use fill fill() function | Flux Documentation to approximate what’s probably there.
Sorry to unsolution it: Support was unable to active it due to production team saying that they can’t enable it due to me being on the free plan. Looking for new solutions.
I just need to be able to square a number. like 2^3 = 8
You can do that and much more if you switch from InfluxQL to Flux or SQL Though that might require jumping to a different version of influx DB as well.
That last one (3) is the correct number (thanks) but I can only add a field but can not add * 0.16 to the end, also to grab the wind speed, i have to make a query but this shows up in the graph, is there a way to get rid of this?
Thanks everyone for the help, sorry for the slow reply
