I want to collect and calculate the mean and standard deviation in the Global Table. I would like to ask how to use Process Flow to calculate
Table gt1=Table("GlobalTable1");
int numrows=gt1.numRows;
string sql="SELECT SUM([Process time])/count(*) FROM GlobalTable1";
Table result=Table.query(sql);
double mean=result[1][1];
gt1[numrows]["Mean"]=mean;
sql="SELECT SUM(Math.sqr([Process time]-"+string.fromNum(mean,6)+")) FROM GlobalTable1";
result=Table.query(sql);
gt1[numrows]["SD"]=Math.sqrt(result[1][1]/numrows);
@Jason Lightfoot Thank you for your reply. In addition, I also want to find the maximum and minimum values. I don't know how to write the code. Please help me too.
When do you want to find those - every time a row is added? Use MAX([Process time]) and MIN([Process time]) as described here.
15 People are following this question.
