Splunk Search

Average of different field values

tunix
New Member

Hi There

I want a simple table-view, with following information:
Name of different views, how often they were requestet per month (average).

My search is looking like this:

index="idx_MYINDEX" | bin _time span=1d | stats count as Views by _time,View_Name | fields - count | sort -Views

Result:

TimeStamp ViewName Views (count)

Now i want an average of each different field value in View_Name (in this example, I tryed it for a timespan 1d - not month)

Can someone please help me? I've tryed with "| stats avg(View_Name) but it didn't do what I expected.

Thank you in advance!

Tags (3)
0 Karma

MuS
Legend

Hi tunix,

So here is our co-anser :slightly_smiling_face:

MuS suggested this:

index="idx_MYINDEX" | bin _time span=1d | stats count as Views by _time,View_Name | timechart span=1d avg(Views) as avg_Views by View_Name

this should give you the result you expect

tunix replied and used this:
Thanks for help - this works for me..

index="idx_MYINDEX" | bin _time span=1d | stats count as Views by _time,View_Name | stats avg(Views) as avg_Views by View_Name | sort - Views

Cheers, MuS

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...