MarkLogic 9 Product Documentationcts:avg
cts:avg( $arg as xs:anyAtomicType* ) as xs:anyAtomicType?
Summary
[DEPRECATED: use cts:avg-aggregate]
fn:avg except each item in the
sequence is multiplied by cts:frequency before summing.
| Parameters | |
|---|---|
| arg | The sequence of values to be averaged. The values should be the result of a lexicon lookup. |
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 always be 0.
Example
xquery version "1.0-ml";
(:
This query assumes an int range index
is configured in the database. It
generates some sample data and then
performs the aggregation in a separate
transaction.
:)
for $x in 1 to 10
return
xdmp:document-insert(fn:concat($x, ".xml"),
<my-element>{
for $y in 1 to $x
return <int>{$x}</int>
}</my-element>);
cts:avg(cts:element-values(xs:QName("int"), (),
("type=int", "item-frequency"))),
cts:avg(cts:element-values(xs:QName("int"), (),
("type=int", "fragment-frequency")))
=>
7
5.5