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);
15 People are following this question.
