nthMostFrequent(tablelens,n,column [,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])
Calculate the nth most frequently occurring value in the specified column.
Parameters
tableLens the tableLens object of the table
n the nth most frequent value to search
column column label of the column to summarize
condition condition on the column to summarize
Return
nth most frequently occurring value in a column
Example
text =
nthMostFrequent(Table1.tableLens,2,'Quantity',
"Discount>0");
See Also
nthMostFrequent(n, cellRange), for the Table version.
| << nthLargest(tablelens,n,column[,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | nthSmallest(tablelens,n,column[,condition]) >> |