pthPercentile(p, column[, 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 pth percentile, by group, of values in a specified column. The pth percentile is the value below which p percent of the records in the group fall. The pthPercentile() function is only available to elements within a Section.
Parameters
p desired percentile value
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
p-th percentile of all values in a group
Example
text = pthPercentile(p,"Quantity", "State",
"field['Discount']>0");
See Also
pthPercentile(tablelens,p,column[, group,condition]), for the Table version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << populationVariance(column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.5) | product(column[, group[,condition]]) >> |