Loading TOC...


   $outCol as item(),
   [$inCol as item()],
   [$options as map:map]
) as map:map


This function counts the rows where the specified input column has a value. If the input column is omitted, all rows in the group or row set are counted. The result is used for building the parameters used by the op:group-by function.

$outCol The name to be used for the column values.
$inCol The columns to be counted.
$options The options can take a values key with a 'distinct' value to count the distinct values of the column.


xquery version "1.0-ml";

import module namespace op="http://marklogic.com/optic"
     at "/MarkLogic/optic.xqy";

let $expenses := op:from-view("main", "expenses")

return $expenses
	          => op:group-by("Category", op:count("Number of Expenses", "Amount", map:entry('values', 'distinct')))
	          => op:order-by("Category")
	          => op:result()

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