Splunk Search

timechart - how do I combine these two charts into one?

zzztimbo
Engager

I have the following query:

... | timechart avg(Latency)

Can I combine this with:

... | timechart count by responseCode

Basically I'd like to have these two charts share the same Y-axis.

Tags (2)
1 Solution

sideview
SplunkTrust
SplunkTrust

Only way I can think of is the somewhat brute force way of using appendcols and running the search twice:

<your search> | timechart span=1d count by responsecode | appendcols [ <your search> | timechart avg(Latency) as avgLatency | fields avgLatency ]

However maybe someone else can see some nutty way of using bin _time and stats to get you there.

View solution in original post

sideview
SplunkTrust
SplunkTrust

Only way I can think of is the somewhat brute force way of using appendcols and running the search twice:

<your search> | timechart span=1d count by responsecode | appendcols [ <your search> | timechart avg(Latency) as avgLatency | fields avgLatency ]

However maybe someone else can see some nutty way of using bin _time and stats to get you there.

abhayneilam
Contributor

Awesome, helped me a lot !!

Thanks !!

0 Karma

nnips
Engager

thanks you so much

0 Karma

dreamwork801
Path Finder

Helped me too!

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...