we are collecting wind data including wind gusts.The actual Wind gusts are stored in the table 1 as a value.
How can I display the averaging of the last 10 minutes without excluding the zero values?
At the moment I have the expression as follows:
But with this formula I get false results because the 0 values are included in the calculation.
If it would not affect your data where it is used elsewhere, you could write the datalogger program to store all 0 values as NAN in the data table. The documentation for the AvgRunOverTime states that all NAN, INF, and -INF values are ignored by the function.
However, having a 0 reflected as a NAN may not work for your other uses.
Best, Dana W.