Loading TOC...


   $arg as xs:double*,
   $p as xs:double*
) as xs:double*


Returns a sequence of percentile(s) given a sequence of percentage(s). This function works like math:percentile except each item in the sequence is repeated cts:frequency times before calculating the percentile(s). The function returns the empty sequence if either $arg or $p is the empty sequence.

arg The sequence of values. The values should be the result of a lexicon lookup.
p The sequence of percentage(s).

Usage Notes

This function is designed to take a sequence of values returned by a lexicon function (for example, cts:element-values); if you input non-lexicon values, the result will be the empty sequence.


xquery version "1.0-ml";

   This query assumes an element range index of type 'int'
   is configured for the 'int' element in the database. It
   generates some sample data and then performs the aggregation
   in a separate transaction.
for $x in 1 to 10
xdmp:document-insert(fn:concat($x, ".xml"),
  for $y in 1 to $x
  return <int>{$x}</int>

cts:percentile(cts:element-values(xs:QName("int"), (),
               ("type=int", "item-frequency")), (0.25,0.5,0.75))

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.