rare

Shows the least common values.

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:

This operator is the dual to top.

summarize x, count=count()
sort count

`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