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 | What is broken 80% of the time by February?

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

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...