Splunk Search

Summarize data on xyseries chart

indeed_2000
Builder

Hi

I have spl command like this: 

| rex "duration\[(?<duration>\d+)\].*?method:\s(?<method>[^\s]+)" | xyseries _time method duration

 

it will produce lots of point on chart, how can I reduce number of points on chart?

for example in 1 minute over 100 “duration” points exist , I want to create 1 point each minutes and show average of that 100 point on single point per minute.

 

any idea?

 Thanks 

Labels (2)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| rex "duration\[(?<duration>\d+)\].*?method:\s(?<method>[^\s]+)"
| timechart span=1m avg(duration) as averageDuration by method

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| rex "duration\[(?<duration>\d+)\].*?method:\s(?<method>[^\s]+)"
| timechart span=1m avg(duration) as averageDuration by method