mvcount()

Table of Contents
This command is experimental

Definition

mvcount() takes a column as an argument and returns the count of the values in that column. If the column does not contain any values, this function returns null.

Examples

The following example counts the amount of values in the multivalue column 'employees'. It returns three as result.

| makeresults
| eval employees=mvappend("Alice", "Bob", "Carlos")
| eval count=mvcount(employees)
Screenshot of the previous example’s result

Currently, mvcount() can’t count single value columns. See the issue on GitHub.

Further Reading