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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...