Splunk Search

How can I calculate stats of a chart list?

yk010123
Path Finder

I have the following query : 

 

... | chart list(time) by request  actor

 

Where time it returns the time for each actor such as 

 

actor1actor2

10

20

10
  
  

 

How can I add a new column with the averages for each one?

Labels (1)
0 Karma

yuanliu
SplunkTrust
SplunkTrust

You didn't list the first column of the chart.  If I understand your chart correctly, that would be request.  Thus, just run avg() by request.

| stats avg(*) as * by request

 

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

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

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...