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!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...