Splunk Search

how does "Other" get calculated in a timechart?

dang
Path Finder

I've got a splunk query like the following:

...| timechart span=10m max(CurrentAnonymousUsers) by ComputerName

Because there are more than 20 distinct computer names, when I graph the data, there is a column titled "Other" and then some of the other distinct names. How does this "Other" column get calculated? I assume it's an average of the lower n values or something? Is there some way to modify the number of items that are included in "Other"?

Tags (1)
1 Solution

sideview
SplunkTrust
SplunkTrust

it will calculate the top values for the particular metric overall. So in this case the 10 should be the 10 ComputerName values that had the highest max(CurrentAnonymousUsers).

If you want to increase it from the default of 10, you use the limit keyword, like to have it display the top 50 and roll up the rest into "other":

...| timechart span=10m limit=50 max(CurrentAnonymousUsers) by ComputerName

the docs explain this as well although the examples don't include an example of limit.

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/timechart

View solution in original post

sideview
SplunkTrust
SplunkTrust

it will calculate the top values for the particular metric overall. So in this case the 10 should be the 10 ComputerName values that had the highest max(CurrentAnonymousUsers).

If you want to increase it from the default of 10, you use the limit keyword, like to have it display the top 50 and roll up the rest into "other":

...| timechart span=10m limit=50 max(CurrentAnonymousUsers) by ComputerName

the docs explain this as well although the examples don't include an example of limit.

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/timechart

Get Updates on the Splunk Community!

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...