Dashboards & Visualizations

Single graph from Multi search index

BharathKN
New Member

Hi, I need a chart from multiple source and multiple search terms.

search 1: index="SessionController" host = "abc01*" | stats distinct_count(session) by date_hour
search 2: index="CompleteSale" host = "xyz*" | stats distinct_count(order) by date_hour

I want a line graph that will show number of requests (i.e. count of Session's) and the orders per hour.

Thanks in advance.

0 Karma

knielsen
Contributor

If the session and order fields are exclusively used on the source where you want to count them, you can simply combine your searches:

(index="SessionController" host = "abc01*") OR (index="CompleteSale" host = "xyz*") | stats distinct_count(session) distinct_count(order) by date_hour
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...