Dashboards & Visualizations

2 searches 2 sources one chart???

ashishv
Explorer

hello all,

i have 2 searches each with its own source, and i need to time chart that over 24 hrs in single chart? i cant figure out how to do that...

here are the searches: Search1: host="SOURCE1" PROCESSFLAG=SUCCESS| timechart span="1h" count by PROCESSFLAG

Search2: host="SOURCE2" NOT ORDER_STATUS ORDER_STATUS="Entered" OR ORDER_STATUS="Booked" | timechart span="1h" count by ORDER_STATUS

Thanks Ashish

Tags (1)
0 Karma
1 Solution

David
Splunk Employee
Splunk Employee

I think the following should give you what you want.

host="SOURCE1" PROCESSFLAG=SUCCESS
   | timechart span="1h" count by PROCESSFLAG 
   | join _time 
     [search host="SOURCE2" NOT ORDER_STATUS ORDER_STATUS="Entered" OR ORDER_STATUS="Booked"  
        | timechart span="1h" count by ORDER_STATUS
     ]

Let me know if that works out.

View solution in original post

0 Karma

David
Splunk Employee
Splunk Employee

I think the following should give you what you want.

host="SOURCE1" PROCESSFLAG=SUCCESS
   | timechart span="1h" count by PROCESSFLAG 
   | join _time 
     [search host="SOURCE2" NOT ORDER_STATUS ORDER_STATUS="Entered" OR ORDER_STATUS="Booked"  
        | timechart span="1h" count by ORDER_STATUS
     ]

Let me know if that works out.

0 Karma

ashishv
Explorer

Wow this is cool..
thanks

0 Karma
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...