correlation(tablelens,column1,column2 [,condition])
average(tablelens,column[,condition])
concat(tablelens,column[,condition])
correlation(tablelens,column1,column2 [,condition])
count(tablelens,column[,condition])
countDistinct(tablelens,column[,condition])
covariance(tablelens,column, column2[, group[,condition]])
max(tablelens,column[,condition])
median(tablelens,column[,condition])
min(tablelens,column[,condition])
mode(tablelens,column[,condition])
nthLargest(tablelens,n,column[,condition])
nthMostFrequent(tablelens,n,column [,condition])
nthSmallest(tablelens,n,column[,condition])
populationStandardDeviation(tablelens,column [,condition])
populationVariance(tablelens,column [,condition])
pthPercentile(tablelens,p,column[, group,condition])
product(Tablelens,column[, condition])
standardDeviation(tablelens,column [,condition])
sum(tablelens,column[,condition])
Calculates the correlation between two columns.
Parameters
tableLens the tableLens object of the table
column1 column label of the primary column
column2 column label of the column to correlate
condition condition on the group to summarize
Return
correlation between the two columns
Example
text = correlation(Table1.tableLens,'Quantity','Total',
"Discount>0");
See Also
correlation(column, column2[, group[,condition]]), for the Section version.
SI.6, Table Object , for additional functions pertaining to Tables.
Data Tables, for scripting issues related to fixed Tables.
| << concat(tablelens,column[,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.5) | count(tablelens,column[,condition]) >> |