Skip to main content
Version: Next

rare

Shows the least common values. The dual to top.

rare x:field

Description​

Shows the least common values for a given field. For each unique value, a new event containing its count will be produced. In general, rare x is equivalent to:

summarize x, count=count()
sort count
Potentially High Memory Usage

Take care when using this operator with large inputs.

x: field​

The name of the field to find the least common values for.

Examples​

Find the least common values​

from {x: "B"}, {x: "A"}, {x: "A"}, {x: "B"}, {x: "A"}, {x: "D"}, {x: "C"}, {x: "C"}
rare x
{x: "D", count: 1}
{x: "C", count: 2}
{x: "B", count: 2}
{x: "A", count: 3}

Show the five least common values for id.orig_h​

rare id.orig_h
head 5