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!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

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

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...