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!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...