Skip to main content
Version: Next

top

Shows the most common values. The dual to rare.

top x:field

Description​

Shows the most common values for a given field. For each value, a new event containing its count will be produced. In general, top 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 field to find the most common values for.

Examples​

Find the most common values​

from [
  {x: "B"},
  {x: "A"},
  {x: "A"},
  {x: "B"},
  {x: "A"},
  {x: "D"},
  {x: "C"},
  {x: "C"},
]
top x
{x: "A", count: 3}
{x: "B", count: 2}
{x: "C", count: 2}
{x: "D", count: 1}

Show the 5 top-most values​

top id.orig_h
head 5