correlation(column, column2[, group[,condition]])
average(column[, group[,condition]])
concat(column[, group[,condition]])
correlation(column, column2[, group[,condition]])
count(column[, group[,condition]])
countDistinct(column[, group[,condition]])
covariance(column, column2[, group[,condition]])
max(column[, group[,condition]])
median(column[, group[,condition]])
min(column[, group[,condition]])
mode(column[, group[,condition]])
nthLargest(n, column[, group[,condition]])
nthMostFrequent(n, column[, group[,condition]])
nthSmallest(n, column[, group[,condition]])
populationStandardDeviation(column[, group,condition])
populationVariance(column[, group[,condition]])
pthPercentile(p, column[, group[,condition]])
product(column[, group[,condition]])
standardDeviation(column[, group[,condition]])
sum(column[, group[,condition]])
Calculates the correlation between two columns. This function is only available to elements within a Section.
Parameters
column column label of the primary column
column2 column label of the column to correlate
group column label of the group to summarize
condition condition on the group to summarize
Return
correlation between the two columns
Example
text = correlation('Quantity','total','State',
"field['Discount']>0");
See Also
correlation(tablelens,column1,column2 [,condition]), for the Table version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << concat(column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | count(column[, group[,condition]]) >> |