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 http://www.leansixsigmadefinition.com/glossary/nelson-rules/

Please help me on this

https://docs.influxdata.com/influxdb/v1.8/query_language/functions/#mean

https://docs.influxdata.com/influxdb/v1.8/query_language/functions/#stddev

Regards,

Antony.

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