Loading TOC...

cts:avg-aggregate

cts:avg-aggregate(
   $range-index as cts:reference,
   [$options as xs:string*],
   [$query as cts:query?],
   [$forest-ids as xs:unsignedLong*]
) as xs:anyAtomicType?

Summary

Returns the average of the values given a value lexicon. This function works like cts:avg except it performs the calculation in parallel in all data nodes then aggregates the values. It generally performs better than cts:avg, especially on large clusters.

Parameters
range-index Reference to a range index.
options Same as the "options" parameter in cts:aggregate.
query Same as the "query" parameter in cts:aggregate.
forest-ids Same as the "forest-ids" parameter in cts:aggregate.

Example

xquery version "1.0-ml";

  (:
     This query assumes an element range index is configured
     in the database for the 'Amount' element.
  :)

cts:avg-aggregate(cts:element-reference(xs:QName("Amount")))

=> 122.2933333333333355

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