Skip to content
Legacy docs for Tenzir v5.x. For the latest Tenzir v6 series, visit docs.tenzir.com. Migrating from v5? Read the Tenzir v6 migration guide.

Returns a list of all grouped values alongside their frequency.

value_counts(xs:list) -> list

The value_counts function returns a list of all unique non-null values in xs alongside their occurrence count.

The values to evaluate.

from {x: 1}, {x: 2}, {x: 2}, {x: 3}
summarize counts=value_counts(x)
{counts: [{value: 1, count: 1}, {value: 2, count: 2}, {value: 3, count: 1}]}

Last updated: