All Apps and Add-ons

Overlay two time based grouped results in a Chart

lslschr
Engager

 

 

 

 

index=xy device_event_class_id=Bandwidth earliest=-1d@d latest=-0d@d  
| rex field=msg "msg=.+raffic.+'(?<pg_name>[\w\s\-]+)'.+(?<bps>\d+\.\d+\s.+)\..+"   
| eval ReportKey="yersterday" 
| timechart span=3h count by pg_name 
| append [search index=xy device_event_class_id=Bandwidth earliest=-2d@d latest=-1d@d 
| rex field=msg "msg=.+raffic.+'(?<pg_name>[\w\s\-]+)'.+(?<bps>\d+\.\d+\s.+)\..+"   
| eval ReportKey="beforeyesterday" 
| timechart span=3h count by pg_name  ] 
| fillnull value=0 
| eval mytime=strftime(_time, "%H:%M") 
| sort mytime

 

 

 

 

I'm trying to create a chart containing two timecharts for different time frames (today/yesterday). How can I achieve it?
Currently I'm getting it one after another. I'd like basically to overlay one timechart on another one.

lslschr_0-1618497785138.png

 

 

Labels (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

This was answered here 

0 Karma
Get Updates on the Splunk Community!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...