Skip to main content
Version: v4.23

value_counts

Returns a list of all grouped values alongside their frequency.

value_counts(xs:list) -> list

Description​

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

xs: list​

The values to evaluate.

Examples​

Get value counts​

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}]}

See Also​

mode, distinct