Splunk Search

streamstats clarification

echalex
Builder

Hi,

I'm using streamstats to calculate the median for a field and timechart to see the count of events where the field has a value less than a median.

... | streamstats median(bytes) as meby|eval snap=if(bytes>=meby, bytes, "smaller") |timechart count by snap

I just want a clarification whether my assumption is correct. My assumption being that meby will contain the median for all the values of bytes from the entire search. Is my assumption correct?

Tags (2)
0 Karma
1 Solution

Ayn
Legend

No, streamstats handles calculation of stats in a streaming manner (as is implied by the name). From the docs (http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Streamstats 😞

The streamstats command, similar to the stats command, calculates summary statistics on search results. Unlike, stats (which works on the results as a whole), streamstats calculates statistics for each event at the time the event is seen.

If you want to calculate stats on all search results, you'll want to use eventstats instead.

View solution in original post

Ayn
Legend

No, streamstats handles calculation of stats in a streaming manner (as is implied by the name). From the docs (http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Streamstats 😞

The streamstats command, similar to the stats command, calculates summary statistics on search results. Unlike, stats (which works on the results as a whole), streamstats calculates statistics for each event at the time the event is seen.

If you want to calculate stats on all search results, you'll want to use eventstats instead.

echalex
Builder

Great answer! Thanks!
The reason I needed the clarification was that my results with streamstats happened to coincide with the median of the entire result set. So in this case, the result looks identical to using eventstats, but some further testing highlights the differences.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...

How to Break a Kubernetes Pod on Purpose and Let the AI Troubleshooting Agent Find ...

Let's say I've just rolled out a Kubernetes Deployment with a typo in the image tag. Nothing explodes. The pod ...

Splunk Add-on for Microsoft Windows 11.0.3: Parse Once, Search Faster

The updated Splunk Add-on for Microsoft Windows helps customers search Windows events faster by reducing ...