pthPercentile(tablelens,p,column[, group,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 pth percentile of values in the specified column inside a group.
Parameters
tableLens the tableLens object of the table
p the pth percentile to be calculated
column column label of the column to summarize
condition condition on the column to summarize
Return
p-th percentile of all values in a group
Example
text = pthPercentile(Table1.tableLens,99,'Quantity',
"Discount>0");
See Also
pthPercentile(p, column[, group[,condition]]), for the Section version.
| << populationVariance(tablelens,column [,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.5) | product(Tablelens,column[, condition]) >> |