How to apply nelson rules in influx db data

Hi I would like to know if there is any way we can find the mean and standard deviation of a column in the influx db. I am using the 1.x version for influx db.

from the these parameters I need to apply nelson rules also. here is the link for that Nelson Rules – Lean Manufacturing and Six Sigma Definitions

Please help me on this

Regards,

Antony.

Hello @nishadnb,
I recommend using flux in v1.7+. here’s an example of employing stddev() to find anomalies