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!

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...

Announcing the Migration of the Splunk Add-on for Microsoft Azure Inputs to ...

Announcing the Migration of the Splunk Add-on for Microsoft Azure Inputs to Officially Supported Splunk ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...