Refine your search:

2
1

When you have a timechart, by default you get the largest 10 values, then everything else bucketed into OTHER.

Can anyone think of an effective way to get the smallest 10 (or X) in a timechart?

What I have is KBps, and I want to find the values that have the worst performance over time.

asked 01 Dec '10, 00:17

vbumgarner's gravatar image

vbumgarner
2.0k2419
accept rate: 26%

edited 04 May '11, 13:49

jlaw's gravatar image

jlaw ♦
72138


2 Answers:

If you disable OTHER does that have the desired effect? Something like:

... | timechart useother=false limit=10 min(KBps) by host
link

answered 01 Dec '10, 01:17

bwooden's gravatar image

bwooden ♦
2.9k1310
accept rate: 37%

I believe that would show the 10 largest minimums.

I thought of a hacky double search way...

sourcetype=foo [search sourcetype=foo | stats avg(KBps) as avg by host | sort -avg | head 10 | fields + host] | timechart avg(KBps) by host

but I was hoping for something more elegant.

(01 Dec '10, 01:32) vbumgarner

Sure. The answer to this question takes you back to the old clunky syntax for changing how many split-by values would be shown. The old syntax to change from 10 hosts to 50 hosts was:

<your search> | timechart count by host where sum in top50

and this was of course later streamlined to :

<your search> | timechart count by host limit=50

but the old verbose syntax still works, and indeed can can do "bottom50":

<your search> | timechart count by host where sum in bottom50
link

answered 06 May '11, 16:11

sideview's gravatar image

sideview ♦
25.5k3543
accept rate: 46%

Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×285
×281

Asked: 01 Dec '10, 00:17

Seen: 733 times

Last updated: 06 May '11, 16:11

Copyright © 2005-2012 Splunk Inc. All rights reserved.